Hi ,
I am running a simple jdbc program and encountered this problem .
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:537)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
The DB2 driver is in the classpath . The exception is thrown when trying to get the connection . I know that the driver is not able to load the native libraries . I have all the native libraries in c:\programfiles\SQLLIB\bin .I still wonder whats causing the problem . The following is the code snippet.
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
System.out.println("class loaded !!!");
Connection conn = DriverManager.getConnection("jdbc
b2://dbahost:50000/citidata,user=javaprod,password=produser");
System.out.println("connected ");
Thanks
Arun