Servlet and DB2 databases (error 500 )

[Joly M <jo...@gmail.com>]

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