I have jdk installed on my RAQ3.
I have read on this list about the mm.mysql driver. I downloaded the jar
file, placed it in the /usr/jakarta-tomcat/lib directory. I then restarted
tomcat. (I have also restarted httpd on subsequent attempts) As a jar file,
I thought this would be enough. I did not receive any error messages upon
restarting, and the jar file showed up in the start-up message. However, I
get error messages when trying to use jdbc. I have read in some posts that
you need to add the jar file to the classpath. I did this using the export
command, yet still have the same problem. (even if it did work, I don't
know how to make the classpath change permanent since the changes drop off
when you log off.)
I have copied below both the jsp page source, and the main part of the error
message when viewing it. I hope someone can help. I know others have had
similar problems, but I can't find much in the way of a solution.
-------
jsp script
---------
<html>
<head>
</head>
<%@ page language="java" import="java.sql.*" %>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver");
// change this as per your requirements
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/members?user=member&password=testpassword");
Statement stmt = myConn.createStatement();
String query = "select * from members";
ResultSet myResultSet = stmt.executeQuery(query);
if (myResultSet != null) {
while (myResultSet.next()) {
// specify the field name
String name = myResultSet.getString("name");
%>
<%= name %>
<br>
<%
}
}
stmt.close();
myConn.close();
%>
</body>
</html>
------------
error message in browser
------------
Root cause:
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
_0002fjdbctest_0002ejspjdbctest_jsp_0._jspService(_0002fjdbctest_0002ejspjdbctest_jsp_0.java:64)
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.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java: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:812)
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:484)
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
_______________________________________________
cobalt-developers mailing list
[EMAIL PROTECTED]
http://list.cobalt.com/mailman/listinfo/cobalt-developers
