Getting error "Large Objects may not be used in auto-commit mode" while configuring PostgreSQL database.
Issue
- Getting following exception in server.log, while trying to configure
PostgreSQL
database with B*MS.
11:34:22,491 WARN [com.arjuna.ats.arjuna] (MSC service thread 1-5) ARJUNA012125: TwoPhaseCoordinator.beforeCompletion - failed for SynchronizationImple< 0:ffffc0a80066:-5ae1fd11:57b6a12a:37, org.drools.persistence.jta.JtaTransactionSynchronizationAdapter@50e35a09 >: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not update: [org.drools.persistence.info.SessionInfo#1]
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) [hibernate-entitymanager-4.2.23.Final-redhat-1.jar:4.2.23.Final-redhat-1]
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) [hibernate-entitymanager-4.2.23.Final-redhat-1.jar:4.2.23.Final-redhat-1]
...
...
Caused by: org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.
at org.postgresql.largeobject.LargeObjectManager.createLO(LargeObjectManager.java:241) [postgresql-9.1-901.jdbc4.jar:]
Environment
-
Red Hat JBoss Enterprise Application Platform
- 6.4.x
-
Red Hat JBoss BRMS
- 6.3
-
PostgreSQL
- 9.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.