Evelin, The first thing you did wrong was read the readme. :) I'm using the same driver with the same basic setup as you. Place the jar file in %CATALINA_HOME%\common\lib. This will make it available to Tomcat as well as any running web app.
On a side note, you may want to have Tomcat create and maintain a pool of connections for your application rather than create connections in the JSP itself. Of course, you may have a good reason for doing this. If you're interested in the connection pool approach, see the following link: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-exampl es-howto.html Jason -----Original Message----- From: Evelin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 12:49 AM To: [EMAIL PROTECTED] Subject: mysql connector problems Hi I am a newbie and having problems with mysql connector. I download the mysql-connector-java-2.0.14-bin.jar and put the file in the C:\j2sdk1.4.0_02\jre\lib\ext as the readme file instructed. But when I tried to run a jsp file with content: <%@ page language="java" import="java.sql.*" %> <% Class.forName("com.mysql.jdbc.Driver").newInstance(); %> I get the internal server error. Please see below. Can anyone help me by telling me what I did wrong? My system is Windows 2000 Professional system with Service Pack 3 and IE6(SP1) installed. I set the Tomcat to run at port 80 and having no problem viewing the site via http://localhost. The Tomcat version is 4.1.12. Many thanks in advance. Evelin PS: I also tried following and got similar problems. <%@ page language="java" import="java.sql.*" %> <% Class.forName("org.gjt.mm.mysql.Driver"); %> HTTP Status 500 - ---------------------------------------------------------------------- ---------- type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: com.mysql.jdbc.Driver at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper. java:248) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:28 9) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli cationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi lterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa lve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java :480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa lve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java :480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2 396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja va:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcher Valve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja va:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java :480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv e.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java :480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223 ) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proces sConnection(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java: 508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPo ol.java:533) at java.lang.Thread.run(Thread.java:536) root cause javax.servlet.ServletException: com.mysql.jdbc.Driver at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageCont extImpl.java:497) at org.apache.jsp.test_jsp._jspService(test_jsp.java:50) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper. java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:28 9) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli cationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi lterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa lve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java :480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa lve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java :480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2 396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja va:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcher Valve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja va:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java :480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv e.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext .invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java :480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223 ) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proces sConnection(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java: 508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPo ol.java:533) at java.lang.Thread.run(Thread.java:536) ---------------------------------------------------------------------- ---------- Apache Tomcat/4.1.12 ====================================================================== ============= Selama Bulan Suci Ramadhan, ikuti Netkuis Ramadhan, Lomba Design E-Card, Opini Berhadiah hanya di www.plasa.com ====================================================================== ============= -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
