If you are developing jsp/servlet application you must copy the .jar into
../WEB-INF/lib.
If not, should be work ...
"Rob S." wrote:
> 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 [EMAIL PROTECTED] 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
