Bug 794318 (JBEPP-1367)

Summary:	EPP-SP: SQLException: You cannot rollback during a managed transaction! when local-tx-datasource set for gatein-jcr_ecmdemo
Product:	[JBoss] JBoss Enterprise Portal Platform 5	Reporter:	Tomas Kyjovsky <tkyjovsk>
Component:	Site Publisher	Assignee:	Thomas Heute <theute>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	5.2.0.ER06	CC:	epp-bugs, tkyjovsk
Target Milestone:	---
Target Release:	5.2.0.CR01
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/JBEPP-1367
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-11-17 09:05:15 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:

Description Tomas Kyjovsky 2011-11-16 14:59:37 UTC

Workaround Description: Define gatein-jcr_ecmdemo datasource as no-tx-datasource.
project_key: JBEPP

1) install SP on top of EPP-5.2.0.ER6
2) in wcm-ds.xml set gatein-jcr_ecmdemo datasource as local-tx-datasource
3) start server

SQLException - see the attached stacktrace.

4) access http://<host>:8080/ecmdemo

Redirected to the /portal context.

Related SPUB issue: https://jira.exoplatform.org/browse/SPUB-116

Comment 1 Tomas Kyjovsky 2011-11-16 15:03:26 UTC

Suggested solution to this issue is to change configuration of DataSourceProvider service.

http://docs.jboss.org/exojcr/1.14.3-GA/developer/en-US/html_single/#Kernel.DataSourceProvider

Comment 2 Tomas Kyjovsky 2011-11-16 15:06:34 UTC

Link: Added: This issue is related to JBQA-5503

Comment 3 Jared MORGAN 2011-11-16 22:16:14 UTC

Release Notes Docs Status: Added: Documented as Known Issue
Release Notes Text: Added: If gatein-jcr_ecmdemo datasource is set as local-tx-datasource in wcm-ds.xml, a SQL Exception occurs and you can not roll back a transaction. To work around the issue, ensure the gatein-jcr_ecmdemo datasource is set as no-tx-datasource. A fix is being investigated.

Comment 4 Thomas Heute 2011-11-17 09:05:15 UTC

Fixed as part of the "Branding" scripts

Comment 5 Thomas Heute 2011-11-17 09:05:15 UTC

Release Notes Docs Status: Removed: Documented as Known Issue Added: Not Required

Comment 6 Tomas Kyjovsky 2011-11-21 18:38:04 UTC

Doesn't appear for EPP-5.2.0.ER7 + SP-snapshot from Nov-18 @ mysql50