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
Segment Product Component Platform Version Edition
Data & Information Management DB2 Universal Database
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): HP-UX
Software version: 4.0
Software edition:
Reference #: 1106851
IBM Group: Software Group
Modified date: Dec 15, 2005