[Laszlo-dev] Failed to connect to mysql when using 4.1.1

[Henry Minsky]

You're sure the jar file with the driver is in a directory that the
JSP servlet has in it's class  library search path?

On Sun, Jul 27, 2008 at 11:46 PM, Chen Ding <chending0602 at hotmail.com> wrote:
> Hi There,
>
> I have been using 4.0.10 before and am trying to migrate to 4.1.1. But in
> 4.1.1, it failed connecting to mysql. The same program, if I run 4.0.10, it
> works just fine (i.e., being able to retrieve data from mysql), but if I run
> 4.1.1, tomcat will generate the following error message. My understanding is
> that if 4.0.10 runs, it means my tomcat and java configurations are correct.
> The same configurations should work for 4.1.1. Your help is greatly
> appreciated!
>
> Chen Ding
>
>
>
>
> StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
> java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
>         at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1340)
>         at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)
>         at
> org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:148)
>         at
> org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:69)
>         at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
>         at java.lang.Class.forName0(Native Method)
>         at java.lang.Class.forName(Class.java:169)
>         at
> org.apache.jsp.TorturerGUI.modules.object_005fretriever_jsp._jspService(object_005fretriever_jsp.java:58)
>         at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>         at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
>         at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
>         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
>         at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
>         at
> org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
>         at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>         at
> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
>         at
> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
>         at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
>         at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
>         at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
>         at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
>         at java.lang.Thread.run(Thread.java:619)
>
>
> ________________________________
> Time for vacation? WIN what you need. Enter Now!



-- 
Henry Minsky
Software Architect
hminsky at laszlosystems.com