[IBM][JDBC Driver] CLI0600E Invalid connection handle or connection is closed. SQLSTATE=S1000
 Technote (troubleshooting)
 
Problem(Abstract)
Getting the following exception with WebSphere 5.0 data source using DB2 JDBC Provider with DB2 version 8 on UNIX platforms (i.e. AIX, Linux, Solaris and HP-UX) even though all the required environment variables for DB2 JDBC Driver are specified in the WebSphere Variables (from Administrative Console, click on Environment --> Manage WebSphere Variables) .

[1/24/03 12:02:55:763 MST] 6f2067 FreePool E J2CA0046E: Method createManagedConnctionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/ARCHDB1Datasource, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message:
[IBM][JDBC Driver] CLI0600E Invalid connection handle or connection is closed. SQLSTATE=S1000.
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:251)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:172)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:125)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.translateSQLException(WSRdbDataSource.java:397)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getConnection(WSRdbDataSource.java:227)
...

Note: The problem only occurs on UNIX platforms. There is no problem on Windows platforms.
 
Resolving the problem
  • Stop WebSphere's server
    $ stopServer.sh <servername> (e.g. stopSever.sh server1)
  • From UNIX session that will be used to start WebSphere's server, source the db2profile (see Notes)
    $ . ~db2inst1/sqllib/db2profile
  • Start WebSphere's server
    $ startServer.sh <servername> (e.g. startServer.sh server1)
Notes:
  1. startServer.sh and stopServer.sh scripts are in $WAS_HOME/bin directory where $WAS_HOME is the directory where WebSphere Application Server 5.0 is installed.
  2. db2inst1 is the default DB2 instance owner's userid.
  3. db2profile can either be run from the UNIX command line or added to root's .profile (or the user that starts WebSphere's server) or added to the startupServer.sh.
 
 
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 2 Connectivity (J2C)
Operating system(s): Solaris
Software version: 5.0
Software edition:
Reference #: 1104866
IBM Group: Software Group
Modified date: Feb 28, 2003