[jboss-user] [jBPM] - Re: Cannot view a task form in jbpm-console (5.4.0-SNAPSHOT) on EAP 6.0, PostgreSQL and Hibernate 4

[wqe wqe]

wqe wqe [https://community.jboss.org/people/drupalspring] created the discussion

"Re: Cannot view a task form in jbpm-console (5.4.0-SNAPSHOT) on EAP 6.0, PostgreSQL and Hibernate 4"

To view the discussion, visit: https://community.jboss.org/message/755966#755966

--------------------------------------------------------------
Thanks Maciej .

 I agree with you . Handling postgreSQL 's large object type (eg oid , text) in the auto commit mode requires to specify the transaction boundary explicitly .Otherwise , the error "Large Objects may not be used in auto-commit mode" occurs.  

On the other hand , in the non-autocommit mode , it is okay if the transaction boundary is not specify explicitly. So I just try to setup such that the database connection is in the  non-autocommit  by specifying           <property name="hibernate.connection.autocommit" value="false" /> in the persistence.xml . But  no matter how I set in the  persistence.xml and the data source configuration in the standalone.xml , this erro always occurs. So I wonder if the connection get  from the  JBoss AS data source is always in the auto-commit mode and ignores  the setting of persistence.xml or  persistence.xml  .

I temporary resolve this issue by using the local jdbc transaction  instead of getting the connection from the JBoss AS data source , and setting the database connection  in the  non-autocommit   mode. But it is not a nice solution and does not suggested by Java EE specification .Also ,  I  don't know if there are any side-effects.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/755966#755966]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120825/e15dd5c5/attachment.html