I am creating datasource in websphere 6.1 type4 (DB2 Universal JDBC Driver Provider) to DB2 9.5 database.
I am getting the following error
The test connection operation failed for data source DB2DSLOG on server server1 at node dbtusrv01203Node01 with the following exception: java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2ConnectionPoolDataSource. View JVM logs for further details.
Since DB2 is installed in different machine, i have copied db2jcc.jar & db2jcc_license_cu.jar files to websphere machine.
Antony Rajesh wrote:Since DB2 is installed in different machine, i have copied db2jcc.jar & db2jcc_license_cu.jar files to websphere machine.
I feel its having some class path issue.
Your diagnosis is correct. So you copied those jars to some directory on the Websphere machine? So far so good. And when you configured the data source, did you input the name of that directory somewhere? You do have to do that. (I don't remember exactly where but I don't feel like starting up the admin application to find out.)