Statement committed even though autocommit is set to false

Technote (FAQ)
Problem
When using connection pooling with DB2® V7 prior to Fix Pack 8, a statement is committed even though autocommit is set to false. According to the Java™ Database Connectivity (JDBC™) specification, the autoCommit value should not be changed during a global transaction. However, after the global transaction is complete, DB2 returns the autoCommit value of true.
Cause
This error is due to a known code bug in DB2 as described below.
Solution
Install DB2 V7 Fix Pack 8 available on the IBM® DB2 eSupport site:


http://www-306.ibm.com/software/data/support/

Cross Reference information
SegmentProductComponentPlatformVersionEdition
Data & Information ManagementDB2 Universal Database











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, Java 2 Connectivity (J2C)
Operating system(s): Multi-Platform
Software version: 3.5, 4.0, 5.0, 5.1, 6.0
Software edition: Edition Independent
Reference #: 1106851
IBM Group: Software Group
Modified date: 2004-12-01