Oracle RollBacks fail with Bean Managed Persistence (BMP) and unshareable mode
 Technote (troubleshooting)
 
Problem(Abstract)
When running a Global transaction with an unshareable mode where two or more connections are created as part of the Global transaction, Oracle issues the exception:

"ORA-02051: another session in same transaction failed"
when doing a rollback or commit on the Global transaction.
 
Cause
This situation is recognized as an Oracle problem. The Oracle bug number is 2511780.
 
Resolving the problem
Use Shareable mode when running a bean managed persistence or servlet to work around the problem as follows:
For Bean Managed Persistence (BMP)

Set the res-sharing-scope tag to Shareable in the ejb-jar.xml file, which is found in the META-INF directory of the yourbean.jar file.

For example:
<res-sharing-scope>Shareable</res-sharing-scope>

For Servlet

Set the res-sharing-scope tag to Shareable in the web.xml file, which is found in the WEB-INF directory of the .war file.

For example:
<res-sharing-scope>Shareable</res-sharing-scope>

(Note: This information also comes from the WebSphere Application Server 5.0.1 Release Note.)
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): Windows
Software version: 5.0.1
Software edition:
Reference #: 1113276
IBM Group: Software Group
Modified date: May 28, 2004