I'm getting the exact same problem. I donwloaded the mm.mysql driver to connect my JSP
with mySQL. I'm giving the following for my classpath in "autoexec.bat" :
SET CLASSPATH=D:\Allaire\mm.mysql-2.0.4-src.jar\mm.mysql-2.0.4\mysql.jar;%CLASSPATH%
this mysql.jar is what i got along with all the files. i *did not* compile anything.
and i'm getting the same error you are getting.
what is wrong?
Cheers,
Supreme Being
>Date: Thu, 17 May 2001 23:49:16 -0500
>Reply-To: [EMAIL PROTECTED]
>From: Jon Shoberg <[EMAIL PROTECTED]>
>Subject: [ClassPath] JSP, JDBC, and mm.MySql
>To: [EMAIL PROTECTED]
>
> 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)
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
------------------------------------------------------------
Are you a Hoboe? Hobnob at http://www.hoboe.com
Click here -> http://www.hoboe.com Global Mail Access
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
