Bug 852044 - Cannot view human task list on EAP 6.0 with Hibernate 4 and PostgreSQL due to: org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.
Cannot view human task list on EAP 6.0 with Hibernate 4 and PostgreSQL due to...
Product: JBoss Enterprise BRMS Platform 5
Classification: JBoss
Component: jBPM 5 (Show other bugs)
BRMS 5.3.0.GA
Unspecified Unspecified
unspecified Severity high
: ER2
: BRMS 5.3.1 GA
Assigned To: Shelly McGowan
Marek Baluch
Depends On:
Blocks: 1211248
  Show dependency treegraph
Reported: 2012-08-27 08:28 EDT by Jiri Svitak
Modified: 2016-09-20 01:08 EDT (History)
6 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed:
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)
server.log (14.21 KB, text/plain)
2012-08-27 08:28 EDT, Jiri Svitak
no flags Details
business-central-server persistence.xml (1.96 KB, text/plain)
2012-08-27 08:29 EDT, Jiri Svitak
no flags Details
jbpm-human-task persistence.xml (2.43 KB, text/plain)
2012-08-27 08:30 EDT, Jiri Svitak
no flags Details
test case (6.06 KB, application/zip)
2012-08-27 08:37 EDT, Jiri Svitak
no flags Details
standalone.xml (16.57 KB, text/plain)
2012-08-27 11:31 EDT, Jiri Svitak
no flags Details
Another test case (8.02 KB, text/plain)
2012-09-21 03:32 EDT, Marco Rietveld
no flags Details

External Trackers
Tracker ID Priority Status Summary Last Updated
JBoss Issue Tracker JBPM-3763 Major Resolved Make human task service working on JPA2 and postgresql 2016-08-31 06:21 EDT

  None (edit)
Description Jiri Svitak 2012-08-27 08:28:08 EDT
Created attachment 607193 [details]

Cannot view human task list on EAP 6.0 with JPA 2.0 and PostgreSQL due to: org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.

How to reproduce:
1. Set up your environment using the steps in this document:
Ignore the parts about setting up Hibernate 3, instead of that use attached persistence.xml files with JPA 2.0.
2. Run the attached test case. It starts a process instance and connects to the human task server and creates a task there.
3. Open http://localhost:8080/business-central and view your tasks (click on refresh button) of your user (in my case it's jsvitak, but you can easily reconfigure it to krisv for example; in these files: testproc.bpmn2 file, brms-users.properties, brms-roles.properties and DefaultUsers.mvel).
4. You can see an exception in your server, see attached server.log for details.
Business central shows no human tasks, but the task from the testproc should be there. With configured Hibernate 3 you can see the test task and complete it too.

My environment:
EAP 6.0 (with default Hibernate 4)
BRMS 5.3.0 GA patch01 (reconfigure to JPA 2.0 jbpm-human-task.war and business-central-server.war)
PostgreSQL 9

Added also relevant JIRA issue based on this discussion:
Comment 1 Jiri Svitak 2012-08-27 08:29:55 EDT
Created attachment 607194 [details]
business-central-server persistence.xml
Comment 2 Jiri Svitak 2012-08-27 08:30:51 EDT
Created attachment 607195 [details]
jbpm-human-task persistence.xml
Comment 3 Jiri Svitak 2012-08-27 08:37:46 EDT
Created attachment 607197 [details]
test case
Comment 4 Jiri Svitak 2012-08-27 11:31:14 EDT
Created attachment 607237 [details]
Comment 5 Marco Rietveld 2012-09-11 15:28:57 EDT

Could you test this with the new EE6 wars? The jbpm-human-task-war module now makes a new jbpm-human-task-war-<version>-EE6.war that works with EAP 6. 

I tested this problem with EAP 6 (and postgresql 8.4.12) and didn't run into the problem you mention. 

I did run into other problems, unfortunately (1. adding the task w/o the user in the db throws an exception). I haven't completed the task yet either (and let the process complete), I'll test that tomorrow. 

(I can't remember if [1] is intended, but the error thrown is very ugly. At the very least I'll clean that up.)
Comment 6 Marco Rietveld 2012-09-12 03:55:57 EDT
And.. I don't know what I was doing yesterday, but today, I _am_ getting the error you described. 

My apologies! :(
Comment 7 Marco Rietveld 2012-09-21 03:32:33 EDT
Created attachment 615296 [details]
Another test case

What's interesting, is that this error has to do specifically with how hibernate 4 handles transactions -- because this error doesn't happen on AS5/hib3, obviously. 

* Unfortunately, wrapping the session.write() in a transaction introduces other errors into the human-task service. 

I was hoping to get around the problem by using a different jta txm implementation, but the "correct" hib4 setting (hibernate.transaction.jta.platform) doesn't help. The problem also occurs when using bitronix. 

Of course, the problems that I'm seeing in the tests when the session.write() is wrapped, might just be due to a problem in the tests, not the actually code. 

Still looking..
Comment 8 JBoss JIRA Server 2012-10-01 06:27:19 EDT
Marco Rietveld <marco.rietveld@redhat.com> updated the status of jira JBPM-3763 to Resolved
Comment 9 Jiri Svitak 2012-10-04 11:58:28 EDT
Verified in BRMS 5.3.1 ER2.

Note You need to log in before you can comment on or make changes to this bug.