DSRA9350E error when application calls the Connection.setAutoCommit(true) method during a global transaction
 Technote (troubleshooting)
 
Problem(Abstract)
The DSRA9350E error occurs when an application invokes the "Connection.setAutoCommit(true)" method within the context of a distributed transaction.
 
Cause
Excerpt from the IBM® WebSphere® Application Server V5 Information Center:

According to the JDBC™ 2.0 specification, application code is not allowed to call the following methods while in the context of a distributed transaction:

  • Connection.commit

  • Connection.rollback

  • Connection.setAutoCommit(true)
     
Resolving the problem
When a connection is used inside the scope of a distributed transaction, the application code must never call the methods listed above. This is because the transaction manager (in this case WebSphere Application Server) controls when a distributed transaction begins and when it is committed or rolled back. Calling any one of these three methods interferes with the transaction manager control of the transaction boundaries.

When a new connection is created within the scope of a distributed transaction, the auto-commit mode is disabled by default.
 
 
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 Transaction Service (JTS)
Operating system(s): Windows
Software version: 5.1.1
Software edition:
Reference #: 1164676
IBM Group: Software Group
Modified date: Sep 11, 2004