Place your jar file in the WEB-INF/lib folder.
Matt
Jon Shoberg wrote:
>
> Its getting late but I'm not having too much luck at getting a sucessful
> JSP / mysql connection. Given the error message below can someone explain
> where I should be setting my class path and the actual mm.mysql files or the
> entire jar file? I am using jdk1.3 with the latest apache on win2K pro.
>
> My JSP page looks like and the error is below:
>
> <html>
> <head>
> <title>Login</title>
> </head>
> <%@ page import="java.sql.*, java.io.*" %>
> <%
> // Step 1: registering the MySQL JDBC driver
>
> try {
> // The newInstance() call is a work around for some
> // broken Java implementations
> Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> }
> catch (Exception E) {
> out.println("<br><br>some crap<br><br>Unable to load
> driver.<br><br><br><br>");
> E.printStackTrace(new PrintWriter(out));
> }
>
> %>
>
> </html>
>
> error:
>
> java.lang.ClassNotFoundException: Unable to load class
> org.gjt.mm.mysql.Driver at
> org.apache.jasper.servlet.JasperLoader.findClass(JasperLoader.java:223) at
> org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:147) at
> java.lang.ClassLoader.loadClass(ClassLoader.java:253) at
> java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313) at
> java.lang.Class.forName0(Native Method) at
> java.lang.Class.forName(Class.java:120) at
> _0002fsql_0002ejspsql_jsp_7._jspService(_0002fsql_0002ejspsql_jsp_7.java:70)
> 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$JspServletWrapper.service(JspServlet.ja
> va:177) at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at
> org.apache.tomcat.core.Handler.service(Handler.java:286) at
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at
> org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
> 7) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
> 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:498)
> at java.lang.Thread.run(Thread.java:484)
begin:vcard
n:Goss;Matt
tel;fax:919-657-1501
tel;work:919-657-1432
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Matt
end:vcard
