I am using Tomcat 5.0.16 and can't get jdbc working with DB2 8.1 on Linux
Red Hat 9. 

The exact error I get is java.sql.SQLException: No sitable driver

I have tried the following jdbc calls combinations:

Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); // Type2
String url = "jdbc:db2:test"; // Type2

Class.forName("com.ibm.db2.jcc.DB2Driver"); // Type4
String url = " jdbc:db2://localhost:50000/test"; // Type4


conn= DriverManager.getConnection(url, "test", "test");

I have tried copying the db2java.zip as follows:
cp -p /opt/IBM/db2/V8.1/java/db2java.zip $CATALINA_HOME/common/lib/db2java.jar

As well, I have copied it to Put db2java.jar in : %CATALINA_HOME%/lib/ , /server/lib/, 
/common/lib/, ../web-inf/lib

Any suggestions... 

No problems when I used tomcat/db2 on a windows2k machine. 

I wonder if I should go back to an earlier Tomcat or DB2?  
 






_______________________________________________
Juglist mailing list
[EMAIL PROTECTED]
http://trijug.org/mailman/listinfo/juglist_trijug.org

Reply via email to