Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-3763

Make human task service working on JPA2 and postgresql

    Details

      Description

      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]
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                marco.rietveld Marco Rietveld
                Reporter:
                swiderski.maciej Maciej Swiderski
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: