wood burning stoves 2.0*
The moose likes Websphere and the fly likes DB2 Connection Pooling working Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "DB2 Connection Pooling working" Watch "DB2 Connection Pooling working" New topic

DB2 Connection Pooling working

Stephen Haberman

Joined: Aug 10, 2001
Posts: 2
I've been trying for the last few days to connect to a DB2 database from WebSphere 3.5 (on Redhat) using the extended JDBC 2.0 API. Finally I got an answer from someone on a newsgroup, but I thought I'd also post it here because it looks like a lot of people run in to this.
I was getting a ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver (or also COM.ibm.db2.jdbc.DB2XADataSource if JTA is turned on) when trying to use the connectiong pooling via JNDI.
Besides doing usejdbc2 and having all the environment variables setup correctly, you also need to edit the $WAS_HOME/bin/admin.config file and add the /java12/db2java.zip file to the admin's classpath. For me this made everything magically start working.
I agree. Here's the link: http://aspose.com/file-tools
subject: DB2 Connection Pooling working
Similar Threads
Tomcat and DB2
Websphere 5.1 with db2 v7.2 FP 11
Gimme a hand pahdner!!!
Problem with the JDBC driver.
java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver