We have a Domino server that connects to a DB2 server. However, a web application that runs on the Domino server fails to connect to DB2 while using the same ID and password. The error is ‘java.sql.SQLException: No suitable driver’.
The following line of code fails:
con = DriverManager.getConnection(url, userid, password);’
The following debug statements were added to the application’s code:
System.out.println("Driver = "+driver);
System.out.println("url = "+url);
System.out.println("userid= "+userid);
System.out.println("password= "+password);
System.out.println(DriverManager.getDrivers().nextElement().toString());
Here’s the output which shows that the final println statement fails.
12/03/2007 20:04:31 HTTP JVM: Driver = COM.ibm.db2.jdbc.app.DB2Driver
12/03/2007 20:04:31 HTTP JVM: url = jdbc:db2:rofcustp
12/03/2007 20:04:31 HTTP JVM: userid= testUserid
12/03/2007 20:04:31 HTTP JVM: password= testPassWord
I’d appreciate any ideas on why the application fails to connect to DB2 even though the Domino server does connect.
Thanks.