Failing to connect to JDBC resource using the Test Connection button in the administrative console
 Technote (troubleshooting)
 
Problem(Abstract)
A JDBC resource is installed using the administrative console. An attempt to connect to DB2® using the Test Connection button from the JDBC Providers > DB2 for z/OS® Local JDBC Provider (RRS) > Data Sources panel fails, and in the Servant Region of the Server this exception is issued:

java.sql.SQLException:java.lang.NoClassDefFoundError:
COM/ibm/db2os390/sqlj/jdbc/DB2SQLJDriver. View server logs for details.

Also in the Servant Region, the following message can be found:

Could not load dll : /usr/lpp/db2/db2710/lib/libdb2os390j2.so
: EDC5157I An internal error has occurred. (errno2=0x0BDF03B2)
 
Cause
Some of the files in /usr/lpp/db2/db2710/lib are external links to MVS datasets; because these datasets are not in LNKLST or LPA, they are not found.
 
Resolving the problem
Add DB2 MVS datasets to STEPLIB DD in the PROC for the Servant Region.
 
 
 


Document Information


Current web document: swg21180150.html
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: 5.1
Software edition:
Reference #: 1180150
IBM Group: Software Group
Modified date: Mar 25, 2005