DB2 :No suitable driver

[arunij katiliyar]

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

[Masoud Kalali]

Hi
Working with DB2 driver need that you should have license file in the path too.
you should put the : db2jcc_license_cu.jar in class path too.
another thing : AFAIK we should seperate the name value pair with ;
i see that you seperate them with ,
correct them and if you could not connect then post the error messege here.



wish you success.

[arunij katiliyar]

hi Masoud ,
Thanks for the reply . I am not using jcc driver so i dont need the license jar .

Thanks
Arun