error in servlet with oracle

[mohamed mustaq]

hi ,
when i try to connect database in servlet pgming i got this error.
i am using eclipse with jboss server.
if anyone knows please let me know.

the error which i got in browser is
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Servlet.init() for servlet CPlanSer1 threw exception
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:72)
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:275)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
java.lang.Thread.run(Thread.java:595)


root cause

java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver
cplan.CPlanSer1.init(CPlanSer1.java:51)
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:72)
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:275)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
java.lang.Thread.run(Thread.java:595)


note The full stack trace of the root cause is available in the Apache Tomcat/5.0.26 logs.


--------------------------------------------------------------------------------

[Paul Bourdeaux]

java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver

Looks to me like your servlet is not finding the needed driver for the database connection. Are you sure the correct jar is in yyour library directory? Are you using database connection pooling? If you could post the code from your servlet I could try and help more.

On a side note, the "javax.servlet.ServletException: Servlet.init() for servlet CPlanSer1 threw exception" line worries me. Are you establishing a database connection in the init method of your servlet? This in itself has some inherent problems with design. We can discuss those after we figure out what is wrong with the connection.

[Clarke Kent]

check if you included the oracle jdbc jar files in your war file.

[mohamed mustaq]

thanks yar,
i solved the problem by adding class111.jar into jboss/server/lib/class111.jar
it works fine.
thank you