Problem: J2EE Application running in a WebSphere V5.0.2
environment on AIX V5, accessing DB2 V5.0.2 data residing on OS/390 V2.10 via
DB2 Connect V8.1.
In the test environment, connectivity is no problem
whether via WebSphere or via DB2 CLP.
In the production environment, however, connectivity is
still not a problem via DB2 CLP.
However when testing connection via WebSphere Admin
Console TEST CONNECTION button it failed with error
" 505970e6 DataSourceCon E DSRA8040I: Failed to
connect to the DataSource.
Encountered : java.lang.UnsatisfiedLinkError:
SQLConnect at
COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Connection.java(Compiled
Code)) at
COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Connection.java:424) at COM.ibm.db2.jdbc.app.DB2ReusableConnection.<init>
(DB2ReusableConnection.java:69) at
COM.ibm.db2.jdbc.DB2PooledConnection.getConnection(DB2PooledConnection.java:188) at
com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI
DSConfigurationHelper.java:1712) at
java.lang.reflect.Method.invoke(Native Method) at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2
(DataSourceConfigHelperMBean.java:511) at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection
(DataSourceConfigHelperMBean.java:439) at
java.lang.reflect.Method.invoke(Native Method)...."
Both DB2 Connect and WAS are on the same machine.
The only difference is that DB2 Connect on the test
environment was installed for 32-bit architecture, whilst DB2 Connect on
the production environment for 64-bit.
Has anybody come across this problem.
rgds
Jenny Kuan
