tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rob S." <rsli...@sfu.ca>
Subject Re: javax.servlet.ServletException: No suitable driver
Date Thu, 01 Jan 1970 00:00:00 GMT
I always wish I was better with JDBC, but I never manage to find the time to
get down with it... Anyway, did you load the JDBC driver class?  Just
putting it in your classpath doesn't mean that it gets loaded.	To me, it
would appear that the "no suitable driver" when you're trying to connect to
the database would mean that DriverManager.getConnection can't find a
suitable JDBC driver ;)

See any JDBC tutorial on the web, like the ones at http://java.sun.com/

- r

On Tue, 14 Aug 2001 14:57:44 +0300 tomcat-user@jakarta.apache.org wrote:
> Hello,
> 
> I have setup Tomcat-3.2.3 and Apache_1.3.20 with MySQL-3.23.36 under
> RedHatLinux 7.1.
> jdk1.2.2 is installed under /usr/local/src/jdk.
> Tomcat, Apache and MySQL are basically working fine
> I am trying to use MM.MySQL for JDBC connectivity to MySQL.
> my CLASSPATH is /usr/local/src/jdk1.2.2/lib/mm.mysql-2.0.4-src.jar
> This is the log that I have:
> 
> javax.servlet.ServletException: No suitable driver
>	at
>
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp

> l.java:459)
>	at
>
jsp._0002fjsp_0002ftest_0002ejsptest_jsp_7._jspService(_0002fjsp_0002ftest_0

> 002ejsptest_jsp_7.java:96)
>	at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>	at
>
org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja

> va:130)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>	at
>
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja

> va:282)
>	at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
>	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)

>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>	at
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
>	at org.apache.tomcat.core.Handler.service(Handler.java:287)
>	at
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
>	at
>
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81

> 2)
>	at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
>	at
>
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection

> (Ajp12ConnectionHandler.java:166)
>	at
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
>	at
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)

>	at java.lang.Thread.run(Thread.java:479)
> Root cause:
> java.sql.SQLException: No suitable driver
>	at java.sql.DriverManager.getConnection(DriverManager.java:477)
>	at java.sql.DriverManager.getConnection(DriverManager.java:137)
>	at
>
jsp._0002fjsp_0002ftest_0002ejsptest_jsp_7._jspService(_0002fjsp_0002ftest_0

> 002ejsptest_jsp_7.java:67)
>	at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>	at
>
org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja

> va:130)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>	at
>
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja

> va:282)
>	at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
>	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)

>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>	at
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
>	at org.apache.tomcat.core.Handler.service(Handler.java:287)
>	at
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
>	at
>
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81

> 2)
>	at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
>	at
>
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection

> (Ajp12ConnectionHandler.java:166)
>	at
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
>	at
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)

>	at java.lang.Thread.run(Thread.java:479)
> 
> What did I miss?
> 
> Aykal




Mime
View raw message