Here is the error I am getting:
java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:374)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at login.Database.Connect(Database.java:19)
at login.LoginServlet.doGet(LoginServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:637)
I am trying to connect to a DB2 database. I have obtained the db2jcc.jar file (that contains the driver) and have it in my classpath in Eclipse. Here is my code to connect to the database:
public boolean Connect() throws SQLException {
boolean success = false;
String dbName = "DataBaseName";
String userid = "user";
String password = "pass";
String url = "jdbc:db2://192.168.0.1:1/" + dbName;
String driver = "com.ibm.db2.jcc.DB2Driver";
try {
Class.forName(driver).newInstance();
connection = DriverManager.getConnection(url, userid, password);
success = true;
} catch(Exception e) {
e.printStackTrace();
}
return success;
}
I have changed the login information so as not to give out personal information. My question: Am I missing something? I included the .jar file in my [classpath in Eclipse|http://toddgrooms.com/Images/java_db2_buildpath.png] , but I am still having an issue. Any suggestions would be much appreciated. Thank you.