-
Enhancement
-
Resolution: Done
-
Major
-
jBPM 5.3
Task service cannot work with postgresql when configured as JPA 2 (on JBoss AS 7.1.1).
Problem is caused by not all operations are enclosed in transaction and prostgresql will report errors when accessing blob data outside of transaction with following error
Caused by: org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.
at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:198)
at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:170)
at org.postgresql.jdbc2.AbstractJdbc2BlobClob.(AbstractJdbc2BlobClob.java:45)
at org.postgresql.jdbc2.AbstractJdbc2Clob.(AbstractJdbc2Clob.java:23)
at org.postgresql.jdbc3.AbstractJdbc3Clob.(AbstractJdbc3Clob.java:18)
at org.postgresql.jdbc4.AbstractJdbc4Clob.(AbstractJdbc4Clob.java:18)
at org.postgresql.jdbc4.Jdbc4Clob.(Jdbc4Clob.java:16)
an example of this is whe user try to open task for in jbpm console:
Caused by: java.lang.RuntimeException: Command GetTaskRequest faild due to Large Objects may not be used in auto-commit mode.. Please contact task server administrator.
at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:674) [jbpm-human-task-core-5.4.0-SNAPSHOT.jar:5.4.0-SNAPSHOT]
at org.jbpm.task.service.hornetq.HornetQTaskServerHandler.messageReceived(HornetQTaskServerHandler.java:43) [jbpm-human-task-hornetq-5.4.0-SNAPSHOT.jar:5.4.0-SNAPSHOT]
at org.jbpm.task.service.hornetq.BaseHornetQTaskServer.run(BaseHornetQTaskServer.java:104) [jbpm-human-task-hornetq-5.4.0-SNAPSHOT.jar:5.4.0-SNAPSHOT]
