I try to config DB2 8.0 with WebSphere Application Server 6.0. but I got ClassNotFoundException.
xsiw...@hotmail.com
"Test connection failed for data source NimDBConnection on server server1 at node wasservNode01 with the following exception: java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2ConnectionPoolDataSource. View JVM logs for further details.".
Before I config it. I already have to copy JAR file of DB2Connection Driver from database server[/home/db2inst1/sqllib/java] to web server [/usr/IBM/WebSphere/AppServer/db2/lib]
set The Class Path like that :
WAS_INSTALL_ROOT /usr/IBM/WebSphere/AppServer
UNIVERSAL_JDBC_DRIVER_PATH ${WAS_INSTALL_ROOT}/universalDriver/lib
CLOUDSCAPE_JDBC_DRIVER_PATH ${WAS_INSTALL_ROOT}/cloudscape/lib
DB2UNIVERSAL_JDBC_DRIVER_PATH ${WAS_INSTALL_ROOT}/db2/lib
DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH ${WAS_INSTALL_ROOT}/db2/lib
Some part of the log file
2/1/07 11:45:25:602 ICT] 00000045 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
[2/1/07 11:45:25:602 ICT] 00000045 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
[2/1/07 11:45:25:619 ICT] 00000045 SystemErr R java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2ConnectionPoolDataSource
at java.net.URLClassLoader.findClass(URLClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java(Compiled Code))
at com.ibm.ws.rsadapter.DSConfigurationHelper.loadDataSourceClass(DSConfigurationHelper.java:1404)
at com.ibm.ws.rsadapter.DSConfigurationHelper$7.run(DSConfigurationHelper.java:2119)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2117)
Please some one help me and give me the light.....
Anantha
Try to install the DB2 Client and test the jdbc connection. Then try
using from WebSphere.
Sacha
> I try to config DB2 8.0 with WebSphere Application Server 6.0 on IBM AIX , They are not in same server . when I test connection on ibm/console page, i got message
> "Test connection failed for data source NimDBConnection on server server1 at node wasservNode01 with the following exception: java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2ConnectionPoolDataSource. View JVM logs for further details.".
> Before I config it. I already have to copy JAR file of DB2Connection Driver from database server[/home/db2inst1/sqllib/java] to web server [/usr/IBM/WebSphere/AppServer/db2/lib]
>
> set The Class Path like that :
> WAS_INSTALL_ROOT /usr/IBM/WebSphere/AppServer
> UNIVERSAL_JDBC_DRIVER_PATH ${WAS_INSTALL_ROOT}/universalDriver/lib
> CLOUDSCAPE_JDBC_DRIVER_PATH ${WAS_INSTALL_ROOT}/cloudscape/lib
> DB2UNIVERSAL_JDBC_DRIVER_PATH ${WAS_INSTALL_ROOT}/db2/lib
> DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH ${WAS_INSTALL_ROOT}/db2/lib
> Some part of the log file
> [2/1/07 11:45:25:602 ICT] 00000045 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
> [2/1/07 11:45:25:619 ICT] 00000045 SystemErr R java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2ConnectionPoolDataSource
> at java.net.URLClassLoader.findClass(URLClassLoader.java(Compiled Code))
> at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
> at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Class.java(Compiled Code))
> at com.ibm.ws.rsadapter.DSConfigurationHelper$7.run(DSConfigurationHelper.java:2119)
> at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
> at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2117)
>
> Please some one help me and give me the light.....
Are you running on ND? Perhaps you could review your WS var's. I ran
into some inexplicable situations a while ago, that were caused by
vars that I defined at cell level scope, but somehow also existed at
node (or server for that matter) level. Even vars without actual
value, higher in the hiërarchy, will cause unexpected results.
Sacha
faisal.taimoor
> "Test connection failed for data source NimDBConnection on server server1 at node wasservNode01 with the following exception: java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2ConnectionPoolDataSource. View JVM logs for further details.".
> Before I config it. I already have to copy JAR file of DB2Connection Driver from database server[/home/db2inst1/sqllib/java] to web server [/usr/IBM/WebSphere/AppServer/db2/lib]
>
> set The Class Path like that :
> WAS_INSTALL_ROOT /usr/IBM/WebSphere/AppServer
> UNIVERSAL_JDBC_DRIVER_PATH ${WAS_INSTALL_ROOT}/universalDriver/lib
> CLOUDSCAPE_JDBC_DRIVER_PATH ${WAS_INSTALL_ROOT}/cloudscape/lib
> DB2UNIVERSAL_JDBC_DRIVER_PATH ${WAS_INSTALL_ROOT}/db2/lib
> DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH ${WAS_INSTALL_ROOT}/db2/lib
> Some part of the log file
> [2/1/07 11:45:25:602 ICT] 00000045 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1455)
> [2/1/07 11:45:25:619 ICT] 00000045 SystemErr R java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2ConnectionPoolDataSource
> at java.net.URLClassLoader.findClass(URLClassLoader.java(Compiled Code))
> at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
> at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Class.java(Compiled Code))
> at com.ibm.ws.rsadapter.DSConfigurationHelper$7.run(DSConfigurationHelper.java:2119)
> at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
> at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2117)
>
> Please some one help me and give me the light.....
There are multiple required jars see the documentation to use a type 4
driver for db2 and jars to include in the class path of the server
shared/app