3 Replies Latest reply on Apr 19, 2016 10:18 AM by Marco Rietveld

    JBPM5.4:- org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode

    Deepti Tyagi Newbie



      I am facing an issue on importing any package from JBPM-Engine admin console. It's always showing a message stating: Unable to import package(s) – null

      On checking logs, I found that there is an exception being thrown every time I select a package and click on import.

      org.hibernate.exception.GenericJDBCException: could not insert: [org.drools.persistence.info.SessionInfo]


      Environment:- JBPM5.4, PostgreSQL 9.5, JBoss 6.1.0.Alpha1, Hibernate 4.0.0.Final


      On debugging the drools-5.5.0.Final source jars, I found this error occurs in class SingleSessionCommandService at the highlighted line of code where it tries to persist SessionInfo object into postgresql db.


      transactionOwner = txm.begin(); // transactionOwner value changed to true



      persistenceContext.persist( this.sessionInfo );

      txm.commit( transactionOwner );

      Also the standalone.xml datatasource configuration is as follows:-

      <datasource jta="false" jndi-name="java:jboss/datasources/dsbpm" pool-name="dsbpm" enabled="true" use-java-context="true" use-ccm="true">















                              <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>






                          <driver name="postgresql" module="org.postgresql">




      I am attaching the logs and some debug time outputs to provide more detail on it.

      I will really appreciate any help on this.