i hav a problem with JSP and mysql

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sethupnr
    New Member
    • Sep 2007
    • 26
    #1

    i hav a problem with JSP and mysql

    when i'm using a simple JSP-mysql code it shows some HTTP status 500 error.But simple JSP program without databse is running , Please help how to solve this problem. I'm new to JSP.
    my configurations are...


    i installed j2sdk in C:\j2sdk1.4.2_1 6

    then installed jakarte-tomcat in C:\Program Files\Apache Tomcat 4.0 folder

    copied mysql-connector-java-3.0.17-ga-bin.jar to C:\Program Files\Apache Tomcat 4.0\common\lib


    CLASSPATH: C:\j2sdk1.4.2_1 6\lib\tools.jar ;C:\j2sdk1.4.2_ 16\jre\lib\rt.j ar;C:\Program Files\Apache Tomcat 4.0\common\lib\ mysql-connector-java-3.0.17-ga-bin.jar;

    PATH: %SystemRoot%\sy stem32;%SystemR oot%;%SystemRoo t%\System32\Wbe m;C:\j2sdk1.4.2 _16\bin;

    JAVA_HOME: C:\j2sdk1.4.2_1 6\;

    TOMCAT_HOME: C:\Program Files\Apache Tomcat 4.0\;


    error are given below
    Apache Tomcat/4.0.1 - HTTP Status 500 - Internal Server Error

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

    type Exception report

    message Internal Server Error

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

    exception

    javax.servlet.S ervletException : com.mysql.jdbc. Driver
    at org.apache.jasp er.runtime.Page ContextImpl.han dlePageExceptio n(PageContextIm pl.java:457)
    at org.apache.jsp. test$jsp._jspSe rvice(test$jsp. java:92)
    at org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:107)
    at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
    at org.apache.jasp er.servlet.JspS ervlet$JspServl etWrapper.servi ce(JspServlet.j ava:202)
    at org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:382)
    at org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :474)
    at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
    at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:247)
    at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:193)
    at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:243)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 566)
    at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:472)
    at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:943)
    at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:201)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 566)
    at org.apache.cata lina.valves.Cer tificatesValve. invoke(Certific atesValve.java: 246)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 564)
    at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:472)
    at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:943)
    at org.apache.cata lina.core.Stand ardContext.invo ke(StandardCont ext.java:2344)
    at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:16 4)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 566)
    at org.apache.cata lina.valves.Err orDispatcherVal ve.invoke(Error DispatcherValve .java:170)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 564)
    at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:17 0)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 564)
    at org.apache.cata lina.valves.Acc essLogValve.inv oke(AccessLogVa lve.java:462)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 564)
    at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:472)
    at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:943)
    at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:163)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 566)
    at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:472)
    at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:943)
    at org.apache.cata lina.connector. http.HttpProces sor.process(Htt pProcessor.java :1011)
    at org.apache.cata lina.connector. http.HttpProces sor.run(HttpPro cessor.java:110 6)
    at java.lang.Threa d.run(Thread.ja va:534)


    root cause

    java.lang.Class NotFoundExcepti on: com.mysql.jdbc. Driver
    at org.apache.cata lina.loader.Web appClassLoader. loadClass(Webap pClassLoader.ja va:1307)
    at org.apache.cata lina.loader.Web appClassLoader. loadClass(Webap pClassLoader.ja va:1156)
    at org.apache.jasp er.servlet.Jasp erLoader.loadCl ass(JasperLoade r.java:198)
    at org.apache.jasp er.servlet.Jasp erLoader.loadCl ass(JasperLoade r.java:132)
    at java.lang.Class Loader.loadClas sInternal(Class Loader.java:302 )
    at java.lang.Class .forName0(Nativ e Method)
    at java.lang.Class .forName(Class. java:141)
    at org.apache.jsp. test$jsp._jspSe rvice(test$jsp. java:71)
    at org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:107)
    at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
    at org.apache.jasp er.servlet.JspS ervlet$JspServl etWrapper.servi ce(JspServlet.j ava:202)
    at org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:382)
    at org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :474)
    at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
    at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:247)
    at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:193)
    at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:243)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 566)
    at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:472)
    at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:943)
    at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:201)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 566)
    at org.apache.cata lina.valves.Cer tificatesValve. invoke(Certific atesValve.java: 246)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 564)
    at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:472)
    at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:943)
    at org.apache.cata lina.core.Stand ardContext.invo ke(StandardCont ext.java:2344)
    at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:16 4)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 566)
    at org.apache.cata lina.valves.Err orDispatcherVal ve.invoke(Error DispatcherValve .java:170)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 564)
    at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:17 0)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 564)
    at org.apache.cata lina.valves.Acc essLogValve.inv oke(AccessLogVa lve.java:462)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 564)
    at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:472)
    at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:943)
    at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:163)
    at org.apache.cata lina.core.Stand ardPipeline.inv okeNext(Standar dPipeline.java: 566)
    at org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:472)
    at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:943)
    at org.apache.cata lina.connector. http.HttpProces sor.process(Htt pProcessor.java :1011)
    at org.apache.cata lina.connector. http.HttpProces sor.run(HttpPro cessor.java:110 6)
    at java.lang.Threa d.run(Thread.ja va:534)
    Tags: None
    • r035198x
      MVP
      • Sep 2006
      • 13225
      #2
      Apparently the mysql driver class is not being found.
      Check that your classpath really is set correctly.

        Comment

        Previous template Next
        Working...