Connection not closed SQLSTATE=FFFFF and SQLCODE=-1000003 error when application attempts to connect to DB2
 Technote (FAQ)
 
Problem
The following error was received in the J2EE application server region when the application was attempting to connect to DB2®.

java.sql.SQLException: DB2SQLJConnection:
The Connection is not on a transaction boundary.
The Connection was NOT closed SQLSTATE=FFFFF and SQLCODE=-1000003
 
Cause
An attempt is being made by the application to close a connection without doing a commit.
 
Solution
The application developer must turn Autocommit ON.
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server for z/OS > DB Connections/Connection Pooling
Operating system(s): z/OS
Software version: 4.0.1
Software edition:
Reference #: 1105692
IBM Group: Software Group
Modified date: Dec 8, 2004