My $CATALINA_HOME is defined as: C:\Program Files\Apache Software Foundation\Tomcat\
On Mon, 29 Nov 2004 07:08:02 -0800, John Najarian <[EMAIL PROTECTED]> wrote: > Hi Carlos, > > I have my mysql-connector-java-3.0.0.15-ga-bin.jar located in: > c:\tomcat\common\lib > > However, I also have it in c:\j2sdk1.4.2_03\lib. I think I put it there > as an initial test of MySQL. > > My $CATALINA_HOME is defined as c:\tomcat, what is your CATALINA_HOME > defined as? > > > > > -----Original Message----- > From: Carlos Bracho [mailto:[EMAIL PROTECTED] > Sent: Saturday, November 27, 2004 4:58 PM > To: Tomcat Users List > Subject: Mysql: Cannot create JDBC driver > > 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(PageContextI > mpl.java:825) > at > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp > l.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:2 > 98) > 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(Application > FilterChain.java:237) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:157) > at > org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter > .java:305) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > FilterChain.java:186) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:157) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > va:214) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex > t.java:104) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at > org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContext > Valve.java:198) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja > va:152) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex > t.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(StandardValveContex > t.java:104) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117 > ) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex > t.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(StandardValveContex > t.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.processConne > ction(Http11Protocol.java:702) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav > a: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] > > -- ------------------------------------------------------------------ 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]