PQ73523: Setting connection autoCommit value to false does not work
 Downloadable files
 
Abstract
Setting connection autoCommit value to false does not work correctly in a global transaction or a local transaction when you use the DB2 Universal JDBC Provider Driver
 
Download Description
This problem happens when users use "DB2 Universal JDBC Provider Driver" to create data sources.

Global transaction scenario: When users call aconnection.setAutoCommit(false) in aglobal transaction, an incorrect exception "DSRA9350E: Operation setAutoCommit is not allowed during a global transaction." was thrown. Users should be able to call Connection.setAutoCommit(false) in a global transaction.

Local transaction scenario: When users call connection.setAutoCommit(false), do work to the connection, and then call connection.setAutoCommit(false) again on the same connection, the second setAutoCommit(false) will commit the work that performs before the second setAutoCommit() call. This behavior is the same as native DB2 universal JDBC driver's behavior, but it is not consistent with the behaviors when using other JDBC drivers in WebSphere. The correct WebSphere behavior is that the second setAutoCommit(false) doesn't commit the previous work.

Users Affected:
WebSphere Application Server users of version 5.0 Datasources with autocommit enabled.

Problem Conclusion:
The proper checking was done to determine the type of transaction, user or global, and throw the exception where necessary.
 
Prerequisites
Please download the UpdateInstaller below to install this fix.
 
URL LANGUAGE SIZE(Bytes)
UpdateInstaller US English 7000000
 
 
Installation Instructions
Please review the readme.txt for detailed installation instructions.
 
URL LANGUAGE SIZE(Bytes)
Readme US English 2031
 
Download package
What is DD?
Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options
PQ73523_Fix 09-03-2003 US English 6002 FTP DD
 
Technical support
1-800-IBM-SERV (U.S. Only)
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers WebSphere Application Server Enterprise AIX, HP-UX, Linux, Multi-Platform, Solaris, Windows 5.0, 5.0.1 Edition Independent
Application Servers Runtimes for Java Technology Java SDK
Problems (APARS) fixed
PQ73523
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 5.0.1
Software edition:
Reference #: 4005479
IBM Group: Software Group
Modified date: Nov 29, 2005