You may want to remove autoReconnect=true from
this and see if you still observe same:
<value>jdbc:mysql://localhost:3306/bankapp1?autoReconnect=true</value>
--- Carlos Bracho <[EMAIL PROTECTED]> wrote:
> 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: [EMAIL PROTECTED]
> MSN: [EMAIL PROTECTED]
>
------------------------------------------------------------------
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
