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

      Hi,

       

      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

      registerRollbackSync();

      persistenceContext.joinTransaction();

      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">

                          <connection-url>jdbc:postgresql://<server>:<port>/bpm</connection-url>

                          <driver>postgresql</driver>

                          <pool>

                              <min-pool-size>2</min-pool-size>

                              <max-pool-size>20</max-pool-size>

                              <prefill>false</prefill>

                              <use-strict-min>false</use-strict-min>

                              <flush-strategy>FailingConnectionOnly</flush-strategy>

                          </pool>

                          <security>

                              <user-name>username</user-name>

                              <password>password</password>

                          </security>

                          <validation>

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

                              <validate-on-match>false</validate-on-match>

                              <background-validation>false</background-validation>

                          </validation>

                      </datasource>

      <drivers>

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

                              <driver-class>org.postgresql.Driver</driver-class>

                          </driver>

                    </drivers>


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

      I will really appreciate any help on this.