JBPM5.4:- org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode
deepti.tyagi Mar 25, 2016 12:53 AMHi,
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.
-
logs.txt.zip 3.1 KB
-
debug.jpg 202.1 KB