Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » Tomcat Users »

Mysql: Cannot create JDBC driver

Carlos Bracho

2004-11-27

Replies:

Hello everybody.

I am writting you because I get this exception ramdonly, I mean,
sometimes happends, sometimes does not.

javax.servlet.ServletException: Cannot create JDBC driver of class ''
for connect URL 'null', cause: No suitable driver
    at org.apache.jasper.runtime.PageContextImpl.doHandlePageException (PageContextImpl.java:825)
    at org.apache.jasper.runtime.PageContextImpl.handlePageException (PageContextImpl.java:758)
    at org.apache.jsp.index_jsp._jspService(index_jsp.java:73)
    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.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:186)
    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:534)

I am using MySql 4.0.20a and the driver jar file is
mysql-connector-java-3.0.14.jar, here you have my xml files:

Server.xml:
(...)
<Context path="/bankApp1" docBase="bankApp1" debug="5"
reloadable="true" crossContext="true">
     <Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_bankApp1_log." suffix=".txt" timestamp="true"/>
     <Resource name="jdbc/bankApp1" auth="Container" type="javax.sql.DataSource"/>
     <ResourceParams name="jdbc/bankApp1">
       <parameter>
         <name>factory</name>
         <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
       </parameter>
       <parameter>
         <name>maxActive</name>
          <value>10</value>
       </parameter>
       <parameter>
         <name>maxIdle</name>
          <value>3</value>
       </parameter>
       <parameter>
         <name>maxWait</name>
          <value>20</value>
       </parameter>
       <parameter>
         <name>username</name>
         <value>tomcat</value>
       </parameter>
       <parameter>
         <name>password</name>
          <value>xxxxxxx</value>
       </parameter>
       <parameter>
         <name>driverClassName</name>
          <value>com.mysql.jdbc.Driver</value>
       </parameter>
       <parameter>
         <name>url</name>
         <value>jdbc:mysql://localhost:3306/bankapp1?autoReconnect=true</value>
       </parameter>
     </ResourceParams>      
   </Context>
(...)

And my web.xml:
(...)
<resource-ref>
    <res-ref-name>jdbc/bankApp1</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>
(...)

Please help as soon as you can.
Regards and thanks

--
------------------------------------------------------------------
Carlos J, Bracho M.                      
"The significant problems we face cannot  
be solved at the same level of thinking    
we were at when we created them."      
Albert Einstein                  
------------------------------------------------------------------
e-mail: carlos.bracho@(protected)
MSN:   cbrachomi@(protected)              
------------------------------------------------------------------

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)

©2008 junlu.com - Jax Systems, LLC, U.S.A.