J2CA0036E and DSRA0023E are logged in SystemOut.log when testing the connection or when attempting to create a connection from an application to a database.
 Technote (troubleshooting)
 
Problem(Abstract)
[6/29/06 13:38:56:670 EDT] 00000050 J2CUtilityCla E J2CA0036E: An
exception occurred while invoking method setDataSourceProperties on
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl used by resource SiBuss DB2_CF : com.ibm.ws.exception.WsException: DSRA0023E: The DataSource implementation class
"COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource" could not be found.
 
Cause
The cause of the problem is that the WebSphere® Application Server java™ virtual machine (JVM) could not find the DB2 jar file in its classpath that contains the implementation class. The most likely cause is that the classpath of the JDBC Provider configuration has used a WebSphere variable, for example, DB2_JDBC_DRIVER_PATH, but the variable has not been set for the corresponding WebSphere application server.
 
Resolving the problem
Check the data source configuration to see if the WebSphere Application Server variable is used in the classpath in the JDBC Provider and ensure the variable is set for the correct scope.

For example, if the J2CA0036E and DSRA0023E are logged in the application server's SystemOut.log, then check the JDBC Provider's configuration to Application Server's DB2_JDBC_DRIVER_PATH variable (if it is used in the JDBC Provider confirguration) and confirm that variable points to the correct location of the driver. Also, confirm that the userID that is used to run the Java™ process has the correct permission to use the driver.

Similarly, if the J2CA0036E and DSRA0023E are logged in the Deployment Manager's (DMgr's) SystemOut.log file, then check the JDBC Provider configuration for the node and cell scopes. Check the JDBC Provider's configuration to see if the variable is used and confirm that variable points to the correct location for the driver (from Administrative Console Resources > WebSphere Variables) and confirm the userID that is used to run the DMgr's process has correct permission to use the driver.

 
 
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 > DB Connections/Connection Pooling
Operating system(s): i5/OS
Software version: 6.1
Software edition:
Reference #: 1265784
IBM Group: Software Group
Modified date: Jul 13, 2007