• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB2 :No suitable driver

 
arunij katiliyar
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Author
Ranch Hand
Posts: 531
Java Mac OS X Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi Masoud ,
Thanks for the reply . I am not using jcc driver so i dont need the license jar .

Thanks
Arun
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic