Hello all,
I'm trying to update a DB2 database via servlet pieces of data coming from an html form, but I'm getting an error message. Basically, everything works well when i make two separated programs : -One sending html forms data to the servlet and another one running a simple java class to update a DB2 database. I'm getting troubles when I try to send data from the servlet to the database. As I'm using two technologies :servlet and databases, i don't really know where Ishould head my investigation for... There is the error message : Etat HTTP 500 - java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver at org.apache.catalina.loader.WebappClassLoader.loadClass( WebappClassLoader.java:1358) at org.apache.catalina.loader.WebappClassLoader.loadClass( WebappClassLoader.java:1204) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at T4DB2Connect.<init>(T4DB2Connect.java:43) at CreateAccount.doGet(CreateAccount.java:39) at CreateAccount.doPost(CreateAccount.java:176) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:206) at filters.ExampleFilter.doFilter(ExampleFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:235) 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:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke( AuthenticatorBase.java:433) 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 :263) at org.apache.coyote.http11.Http11AprProcessor.process( Http11AprProcessor.java:852) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process( Http11AprProtocol.java:584) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508) at java.lang.Thread.run(Unknown Source) java.sql.SQLException: No suitable driver found for jdbc:db2://localhost:50000/USER at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at T4DB2Connect.<init>(T4DB2Connect.java:52) at CreateAccount.doGet(CreateAccount.java:39) at CreateAccount.doPost(CreateAccount.java:176) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter( ApplicationFilterChain.java:206) at filters.ExampleFilter.doFilter(ExampleFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( ApplicationFilterChain.java:235) 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:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke( AuthenticatorBase.java:433) 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 :263) at org.apache.coyote.http11.Http11AprProcessor.process( Http11AprProcessor.java:852) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process( Http11AprProtocol.java:584) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508) at java.lang.Thread.run(Unknown Source) Do I need to include IBM DB2 driver into my servlet? How? How do I configure Web.xml? You might have noticed that I'm quite new, so I will accept any of your advice Joly