I use Tomcat to do JSP and I put the JAR file with my db drivers into
webapps/<context>/WEB-INF/lib directory and they are always found. No need
to alter any class paths.
-----Original Message-----
From: Jon Shoberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 9:49 PM
To: [EMAIL PROTECTED]
Subject: [ClassPath] JSP, JDBC, and mm.MySql
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
===========================================================================
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