Bug 794318 (JBEPP-1367) - EPP-SP: SQLException: You cannot rollback during a managed transaction! when local-tx-datasource set for gatein-jcr_ecmdemo
Summary: EPP-SP: SQLException: You cannot rollback during a managed transaction! when ...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: JBEPP-1367
Product: JBoss Enterprise Portal Platform 5
Classification: JBoss
Component: Site Publisher
Version: 5.2.0.ER06
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.2.0.CR01
Assignee: Thomas Heute
QA Contact:
URL: http://jira.jboss.org/jira/browse/JBE...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-11-16 14:59 UTC by Tomas Kyjovsky
Modified: 2012-02-28 16:28 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-11-17 09:05:15 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker JBEPP-1367 0 None Closed EPP-SP: SQLException: You cannot rollback during a managed transaction! when local-tx-datasource set for gatein-jcr_ecmd... 2012-04-11 17:56:23 UTC

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
Note You need to log in before you can comment on or make changes to this bug.