Bug 961290

Summary: PSQLException: Large Objects may not be used in auto-commit mode
Product: [Retired] JBoss BRMS Platform 6 Reporter: Jiri Locker <jlocker>
Component: BREAssignee: Edson Tirelli <etirelli>
Status: CLOSED NOTABUG QA Contact: Jiri Locker <jlocker>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.0.0   
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
PostgreSQL 9.2
Last Closed: 2013-05-09 15:00:27 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
server.log none

Description Jiri Locker 2013-05-09 11:07:46 UTC
Created attachment 745613 [details]
server.log

Description of problem:
kie-ide fails to deploy due to this exception when persistence is configured with PostgreSQL datasource.

Version-Release number of selected component (if applicable):
DR4

Steps to Reproduce:
1. setup pgsql datasource on eap 6.1
2. change kie-ide.war/<...>/persistence.xml to use pgsql datasource
3. start the server
  
Additional info:
See attached server.log for full exception trace.

Comment 1 Jiri Locker 2013-05-09 11:12:49 UTC
Similar issue with LOBs and PostgreSQL has been fixed for 5.3: bug 852044.

Comment 2 Jiri Locker 2013-05-09 12:00:29 UTC
Probably error in my configuration. When creating datasource in EAP admin console jta attribute of the datsource defaults to true. I didn't check this. Setting jta="true" avoids the exception an kie-ide deploys OK.

Please close as not a bug if this behavior is correct.

Comment 3 Jiri Locker 2013-05-09 12:02:04 UTC
> defaults to true
should be "defaults to false"