Hi,
I am working in UNIX.I tried to connect to DB2(client) which is in windows. when i tried to connect to DB2 from UNIX, it shows No suitable driver. If i connect from windows,it works fine.
Here is my code
import java.sql.*;
public class JdbcTest1 {
public static void main (
String[] args) {
try {
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
String url = "jdbc:db2:dbname";
Connection conn = DriverManager.getConnection(url,username,password);
System.out.println("connection success");
} catch (Exception e) {
e.printStackTrace();
System.err.println("Got an exception! ");
System.err.println(e.getMessage());
}
}
}
Here is the error that i have got,
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:189)
at JdbcTest1.main(JdbcTest1.java:18)
db2java.zip,db2jcc.jar are in my classpath.
kindly give me a solution.
Thanks in advance
[ September 22, 2008: Message edited by: loganathan ]