|
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:
- 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.
- db2inst1 is the default DB2 instance owner's userid.
- 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 |
|
|
|
|
|
|