<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Cannot view a task form in jbpm-console (5.4.0-SNAPSHOT) on EAP 6.0, PostgreSQL and Hibernate 4
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/jsvitak">Jiri Svitak</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/751316#751316">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hello,</p><p>I cannot view a task form in jbpm-console:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre>19:08:28,750 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-69) Large Objects may not be used in auto-commit mode.
19:08:28,751 ERROR [stderr] (Thread-69) org.hibernate.exception.GenericJDBCException: Large Objects may not be used in auto-commit mode.
19:08:28,752 ERROR [stderr] (Thread-69)      at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
19:08:28,752 ERROR [stderr] (Thread-69)      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
19:08:28,752 ERROR [stderr] (Thread-69)      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
19:08:28,752 ERROR [stderr] (Thread-69)      at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:108)
19:08:28,752 ERROR [stderr] (Thread-69)      at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
19:08:28,752 ERROR [stderr] (Thread-69)      at $Proxy136.getClob(Unknown Source)
19:08:28,753 ERROR [stderr] (Thread-69)      at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$4.doExtract(ClobTypeDescriptor.java:108)
19:08:28,753 ERROR [stderr] (Thread-69)      at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:65)
19:08:28,753 ERROR [stderr] (Thread-69)      at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:269)
19:08:28,753 ERROR [stderr] (Thread-69)      at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:265)
19:08:28,753 ERROR [stderr] (Thread-69)      at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:238)
19:08:28,753 ERROR [stderr] (Thread-69)      at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:357)
19:08:28,753 ERROR [stderr] (Thread-69)      at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2704)
19:08:28,753 ERROR [stderr] (Thread-69)      at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1541)
19:08:28,753 ERROR [stderr] (Thread-69)      at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1473)
19:08:28,754 ERROR [stderr] (Thread-69)      at org.hibernate.loader.Loader.getRow(Loader.java:1373)
19:08:28,754 ERROR [stderr] (Thread-69)      at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:640)
19:08:28,754 ERROR [stderr] (Thread-69)      at org.hibernate.loader.Loader.doQuery(Loader.java:850)
19:08:28,754 ERROR [stderr] (Thread-69)      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
19:08:28,754 ERROR [stderr] (Thread-69)      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
19:08:28,754 ERROR [stderr] (Thread-69)      at org.hibernate.loader.Loader.loadCollection(Loader.java:2150)
19:08:28,754 ERROR [stderr] (Thread-69)      at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:61)
19:08:28,754 ERROR [stderr] (Thread-69)      at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:622)
19:08:28,754 ERROR [stderr] (Thread-69)      at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:82)
19:08:28,754 ERROR [stderr] (Thread-69)      at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1805)
19:08:28,755 ERROR [stderr] (Thread-69)      at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:379)
19:08:28,755 ERROR [stderr] (Thread-69)      at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:112)
19:08:28,755 ERROR [stderr] (Thread-69)      at org.hibernate.collection.internal.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:137)
19:08:28,755 ERROR [stderr] (Thread-69)      at org.hibernate.collection.internal.PersistentBag.size(PersistentBag.java:242)
19:08:28,755 ERROR [stderr] (Thread-69)      at org.jbpm.task.utils.CollectionUtils.writeI18NTextList(CollectionUtils.java:234)
19:08:28,755 ERROR [stderr] (Thread-69)      at org.jbpm.task.Task.writeExternal(Task.java:91)
19:08:28,755 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1429)
19:08:28,755 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1398)
19:08:28,755 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1158)
19:08:28,756 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeArray(ObjectOutputStream.java:1346)
19:08:28,756 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1154)
19:08:28,756 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1518)
19:08:28,756 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1483)
19:08:28,756 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1400)
19:08:28,756 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1158)
19:08:28,756 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1518)
19:08:28,756 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1483)
19:08:28,756 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1400)
19:08:28,756 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1158)
19:08:28,757 ERROR [stderr] (Thread-69)      at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:330)
19:08:28,757 ERROR [stderr] (Thread-69)      at org.jbpm.task.service.hornetq.HornetQSessionWriter.write(HornetQSessionWriter.java:44)
19:08:28,757 ERROR [stderr] (Thread-69)      at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:134)
19:08:28,757 ERROR [stderr] (Thread-69)      at org.jbpm.task.service.hornetq.HornetQTaskServerHandler.messageReceived(HornetQTaskServerHandler.java:43)
19:08:28,757 ERROR [stderr] (Thread-69)      at org.jbpm.task.service.hornetq.BaseHornetQTaskServer.run(BaseHornetQTaskServer.java:104)
19:08:28,757 ERROR [stderr] (Thread-69)      at java.lang.Thread.run(Thread.java:662)
19:08:28,758 ERROR [stderr] (Thread-69) Caused by: org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.
19:08:28,758 ERROR [stderr] (Thread-69)      at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:198)
19:08:28,758 ERROR [stderr] (Thread-69)      at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:170)
19:08:28,758 ERROR [stderr] (Thread-69)      at org.postgresql.jdbc2.AbstractJdbc2BlobClob.(AbstractJdbc2BlobClob.java:45)
19:08:28,758 ERROR [stderr] (Thread-69)      at org.postgresql.jdbc2.AbstractJdbc2Clob.(AbstractJdbc2Clob.java:23)
19:08:28,758 ERROR [stderr] (Thread-69)      at org.postgresql.jdbc3.AbstractJdbc3Clob.(AbstractJdbc3Clob.java:18)
19:08:28,758 ERROR [stderr] (Thread-69)      at org.postgresql.jdbc4.AbstractJdbc4Clob.(AbstractJdbc4Clob.java:18)
19:08:28,758 ERROR [stderr] (Thread-69)      at org.postgresql.jdbc4.Jdbc4Clob.(Jdbc4Clob.java:16)
19:08:28,759 ERROR [stderr] (Thread-69)      at org.postgresql.jdbc4.Jdbc4ResultSet.getClob(Jdbc4ResultSet.java:40)
19:08:28,759 ERROR [stderr] (Thread-69)      at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getClob(AbstractJdbc2ResultSet.java:393)
19:08:28,759 ERROR [stderr] (Thread-69)      at org.jboss.jca.adapters.jdbc.WrappedResultSet.getClob(WrappedResultSet.java:783)
19:08:28,759 ERROR [stderr] (Thread-69)      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
19:08:28,759 ERROR [stderr] (Thread-69)      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
19:08:28,759 ERROR [stderr] (Thread-69)      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
19:08:28,759 ERROR [stderr] (Thread-69)      at java.lang.reflect.Method.invoke(Method.java:597)
19:08:28,759 ERROR [stderr] (Thread-69)      at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:104)
19:08:28,760 ERROR [stderr] (Thread-69)      ... 46 more
19:08:28,760 ERROR [org.jbpm.task.service.TaskServerHandler] (Thread-69) Large Objects may not be used in auto-commit mode.: org.hibernate.exception.GenericJDBCException: Large Objects may not be used in auto-commit mode.
     at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:108) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at $Proxy136.getClob(Unknown Source)     at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$4.doExtract(ClobTypeDescriptor.java:108) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:65) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:269) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:265) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:238) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:357) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2704) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1541) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1473) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.loader.Loader.getRow(Loader.java:1373) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:640) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.loader.Loader.doQuery(Loader.java:850) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.loader.Loader.loadCollection(Loader.java:2150) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:61) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:622) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:82) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1805) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:379) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:112) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.collection.internal.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:137) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.hibernate.collection.internal.PersistentBag.size(PersistentBag.java:242) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     at org.jbpm.task.utils.CollectionUtils.writeI18NTextList(CollectionUtils.java:234) [jbpm-human-task-core-5.4.0-SNAPSHOT.jar:5.4.0-SNAPSHOT]
     at org.jbpm.task.Task.writeExternal(Task.java:91) [jbpm-human-task-core-5.4.0-SNAPSHOT.jar:5.4.0-SNAPSHOT]
     at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1429) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1398) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1158) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.writeArray(ObjectOutputStream.java:1346) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1154) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1518) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1483) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1400) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1158) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1518) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1483) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1400) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1158) [rt.jar:1.6.0_31]
     at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:330) [rt.jar:1.6.0_31]
     at org.jbpm.task.service.hornetq.HornetQSessionWriter.write(HornetQSessionWriter.java:44) [jbpm-human-task-hornetq-5.4.0-SNAPSHOT.jar:5.4.0-SNAPSHOT]
     at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:134) [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]
     at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_31]
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)
     at org.postgresql.jdbc4.Jdbc4ResultSet.getClob(Jdbc4ResultSet.java:40)
     at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getClob(AbstractJdbc2ResultSet.java:393)
     at org.jboss.jca.adapters.jdbc.WrappedResultSet.getClob(WrappedResultSet.java:783)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_31]
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_31]
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_31]
     at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_31]
     at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:104) [hibernate-core-4.1.3.Final-redhat-1.jar:4.1.3.Final-redhat-1]
     ... 46 more
19:08:28,794 WARN  [org.hibernate.engine.loading.internal.LoadContexts] (Thread-69) HHH000100: Fail-safe cleanup (collections) : org.hibernate.engine.loading.internal.CollectionLoadContext@5a89a85019:08:28,795 WARN  [org.hibernate.engine.loading.internal.CollectionLoadContext] (Thread-69) HHH000160: On CollectionLoadContext#cleanup, localLoadingCollectionKeys contained [1] entries
19:08:28,795 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/gwt-console-server].[Resteasy]] (http-/127.0.0.1:8080-2) Servlet.service() for servlet Resteasy threw exception: org.jboss.resteasy.spi.UnhandledException: 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.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:340) [resteasy-jaxrs-2.3.3.Final-redhat-1.jar:2.3.3.Final-redhat-1]
     at org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:214) [resteasy-jaxrs-2.3.3.Final-redhat-1.jar:2.3.3.Final-redhat-1]
     at org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:190) [resteasy-jaxrs-2.3.3.Final-redhat-1.jar:2.3.3.Final-redhat-1]
     at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:540) [resteasy-jaxrs-2.3.3.Final-redhat-1.jar:2.3.3.Final-redhat-1]
     at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502) [resteasy-jaxrs-2.3.3.Final-redhat-1.jar:2.3.3.Final-redhat-1]
     at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) [resteasy-jaxrs-2.3.3.Final-redhat-1.jar:2.3.3.Final-redhat-1]
     at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.3.3.Final-redhat-1.jar:2.3.3.Final-redhat-1]
     at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.3.3.Final-redhat-1.jar:2.3.3.Final-redhat-1]
     at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.3.Final-redhat-1.jar:2.3.3.Final-redhat-1]
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.1.Final-redhat-1.jar:1.0.1.Final-redhat-1]
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62) [weld-core-1.1.8.Final-redhat-1.jar:1.1.8.Final-redhat-1]
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59) [classes:]
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.1.2.Final-redhat-1.jar:7.1.2.Final-redhat-1]
     at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.2.Final-redhat-1.jar:7.1.2.Final-redhat-1]
     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:679) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:931) [jbossweb-7.0.16.Final-redhat-1.jar:]
     at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_31]
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]
     ... 1 more
</pre><p>I use EAP 6.0 (JBoss 7.1.2), PostgreSQL 9.0.8. I have built my jBPM from current master (5.4.0-SNAPSHOT) due to human task bugs in 5.3.0.Final. Attaching my persistence.xml files (the first one from jbpm-gwt-console-server, second one from jbpm-human-task-war):</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre><?xml version="1.0" encoding="UTF-8"?><br/><persistence version="2.0"<br/>             xmlns="http://java.sun.com/xml/ns/persistence" <br/>             xmlns:orm="http://java.sun.com/xml/ns/persistence/orm" <br/>             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" <br/>             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_2_0.xsd"><br/><br/>    <persistence-unit name="org.jbpm.persistence.jpa" transaction-type="JTA"><br/>        <provider>org.hibernate.ejb.HibernatePersistence</provider><br/>        <jta-data-source>java:jboss/datasources/jbpmDS</jta-data-source><br/>        <mapping-file>META-INF/JBPMorm-JPA2.xml</mapping-file><br/>        <br/>        <class>org.drools.persistence.info.SessionInfo</class><br/>        <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class><br/>        <class>org.drools.persistence.info.WorkItemInfo</class><br/>        <br/>        <properties><br/>            <property name="hibernate.max_fetch_depth" value="3"/><br/>            <property name="hibernate.hbm2ddl.auto" value="update" /><br/>            <property name="hibernate.show_sql" value="false" /><br/>            <property name="hibernate.connection.autocommit" value="false" /><br/>            <property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform" /><br/>            <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/><br/>        </properties>        <br/>    </persistence-unit><br/></persistence></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre><?xml version="1.0" encoding="UTF-8" standalone="yes"?><br/><persistence version="2.0" <br/>             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence<br/>                                 http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd<br/>                                 http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_2_0.xsd"<br/>             xmlns:orm="http://java.sun.com/xml/ns/persistence/orm"<br/>             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"<br/>             xmlns="http://java.sun.com/xml/ns/persistence"><br/>  <persistence-unit name="org.jbpm.task"><br/>    <provider>org.hibernate.ejb.HibernatePersistence</provider><br/>    <non-jta-data-source>java:jboss/datasources/taskDS</non-jta-data-source><br/>    <!--<jta-data-source>java:jboss/datasources/taskDS</jta-data-source>-->       <br/>    <mapping-file>META-INF/Taskorm.xml</mapping-file><br/>    <class>org.jbpm.task.Attachment</class><br/>    <class>org.jbpm.task.BooleanExpression</class><br/>    <class>org.jbpm.task.Comment</class><br/>    <class>org.jbpm.task.Content</class><br/>    <class>org.jbpm.task.Deadline</class><br/>    <class>org.jbpm.task.Delegation</class><br/>    <class>org.jbpm.task.EmailNotification</class><br/>    <class>org.jbpm.task.EmailNotificationHeader</class><br/>    <class>org.jbpm.task.Escalation</class><br/>    <class>org.jbpm.task.Group</class><br/>    <class>org.jbpm.task.I18NText</class><br/>    <class>org.jbpm.task.Notification</class><br/>    <class>org.jbpm.task.OnAllSubTasksEndParentEndStrategy</class><br/>    <class>org.jbpm.task.OnParentAbortAllSubTasksEndStrategy</class><br/>    <class>org.jbpm.task.PeopleAssignments</class><br/>    <class>org.jbpm.task.Reassignment</class><br/>    <class>org.jbpm.task.Status</class><br/>    <class>org.jbpm.task.SubTasksStrategy</class><br/>    <class>org.jbpm.task.Task</class><br/>    <class>org.jbpm.task.TaskData</class><br/>    <class>org.jbpm.task.User</class><br/>    <properties><br/>      <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/><br/>      <property name="hibernate.max_fetch_depth" value="3"/><br/>      <property name="hibernate.hbm2ddl.auto" value="update" /><br/>      <property name="hibernate.show_sql" value="false" /><br/>      <property name="hibernate.connection.autocommit" value="false" /><br/>      <property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform" /><br/>    </properties><br/>  </persistence-unit><br/></persistence></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>My standalone.xml:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre>                <datasource jta="true" jndi-name="java:jboss/datasources/jbpmDS" pool-name="java:jboss/datasources/jbpmDS_Pool" enabled="true" use-java-context="true" use-ccm="true"><br/>                    <connection-url>jdbc:postgresql://localhost:5432/jbpm</connection-url><br/>                    <driver-class>org.postgresql.Driver</driver-class><br/>                    <driver>postgresql-jdbc4</driver><br/>                    <pool><br/>                        <min-pool-size>2</min-pool-size><br/>                        <max-pool-size>20</max-pool-size><br/>                        <prefill>true</prefill><br/>                    </pool><br/>                    <security><br/>                        <user-name>jbpm</user-name><br/>                        <password>jbpm</password><br/>                    </security><br/>                    <validation><br/>                        <check-valid-connection-sql>SELECT 1</check-valid-connection-sql><br/>                        <validate-on-match>false</validate-on-match><br/>                        <background-validation>false</background-validation><br/>                        <use-fast-fail>false</use-fast-fail><br/>                    </validation><br/>                </datasource><br/>                <datasource jta="false" jndi-name="java:jboss/datasources/taskDS" pool-name="java:jboss/datasources/taskDS_Pool" enabled="true" use-java-context="true" use-ccm="true"><br/>                    <connection-url>jdbc:postgresql://localhost:5432/task</connection-url><br/>                    <driver-class>org.postgresql.Driver</driver-class><br/>                    <driver>postgresql-jdbc4</driver><br/>                    <pool><br/>                        <min-pool-size>2</min-pool-size><br/>                        <max-pool-size>20</max-pool-size><br/>                        <prefill>true</prefill><br/>                    </pool><br/>                    <security><br/>                        <user-name>task</user-name><br/>                        <password>task</password><br/>                    </security><br/>                    <validation><br/>                        <check-valid-connection-sql>SELECT 1</check-valid-connection-sql><br/>                        <validate-on-match>false</validate-on-match><br/>                        <background-validation>false</background-validation><br/>                        <use-fast-fail>false</use-fast-fail><br/>                    </validation><br/>                </datasource></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The problem is caused by working with large data objects in PostgreSQL. I have tried to disable autocommit, but it didn't help. Also I have tried to configure data source taskDS to be JTA datasource, because some web discussions suggested to try using of transactions to solve this, but this didn't help too. Any help will be appreciated, thanks.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/751316#751316">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>