Tomcat MySQL driver problem

jlande37 · #1 25th February 2006, 05:51 AM

I am having trouble conneting to MySQL from a jsp, I can however connect from a test class.
My test page is:

Quote:

<%@ page contentType="text/html; charset =iso-8859-1" language="java" import="java.sql.*" errorPage=""%>
<html>
<head>
<title>Display users from MySQL database</title>
</head>
<body>

<%
// define variables
String User;
String Password;

// define database parameters
String host="localhost"; // put in proper user name
String user="root"; // put in proper password
String pass="";
String db="mysql";
String tbl="user";
String conn;
%>

<table width='85%' border='0'cellpadding='4' cellspacing ='0'>
< tr >
<td width='200'>
User
</td>
<td width='200'>
Password
</td>
</ tr >

<%
Class.forName("com.mysql.jdbc.Driver ");

// create connection string
conn="jdbc:mysql://" + host + "/" + db + "?user=" + user +"&password=" +
pass;

// pass database parameters to JDBC driver
Connection Conn = DriverManager.getConnection(conn );

// query statement
Statement SQLStatement = Conn.createStatement ();

// generate query
String Query = "SELECT User,Password FROM user ORDER BY User asc ";

// get result
ResultSet SQLResult = SQLStatement.executeQuery(Query );

while(SQLResult.next ())
{
User = SQLResult.getString("User ");
Password = SQLResult.getString("Password ");

out.println ("< tr ><td>" + User + "</td><td>" + Password + "</td></ tr >");
}

// close connection
SQLResult.close ();
SQLStatement.close ();
Conn.close ();
%>

</table>
</body>

When I try to load the page I get:

Quote:

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: com.mysql.jdbc.Driver
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)

root cause

javax.servlet.ServletException: com.mysql.jdbc.Driver
org.apache.jasper.runtime.PageContextImpl.doHandle PageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:791)
org.apache.jsp.showUsers_jsp._jspService(org.apach e.jsp.showUsers_jsp:118)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)

root cause

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
org.apache.catalina.loader.WebappClassLoader.loadC lass(WebappClassLoader.java:1352)
org.apache.catalina.loader.WebappClassLoader.loadC lass(WebappClassLoader.java:1198)
org.apache.jasper.servlet.JasperLoader.loadClass(J asperLoader.java:127)
org.apache.jasper.servlet.JasperLoader.loadClass(J asperLoader.java:65)
java.lang.ClassLoader.loadClassInternal(ClassLoade r.java:319)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:164)
org.apache.jsp.showUsers_jsp._jspService(org.apach e.jsp.showUsers_jsp:78)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.15 logs.
Apache Tomcat/5.5.15

My Classpath is:

Quote:

:/opt/jdk1.5.0_06/jre/lib/ext/mysql-connector-java-3.1.12/mysql-connector-java-3.1.12-bin.jar:/opt/jdk1.5.0_06/jre/lib/ext/mysql-connector-java-3.1.12/mysql-connector-java-3.1.12-bin.jar

which I am setting in /etc/profile.d/java.sh, as well as in the tomcat startup script.
I have also copied the mysql-connector-java dir into WEB-INF/lib.
I have tried many of the other suggestions that I have found in this forum and elsewhere, but nothing seems to be doing the trick.
Any help would be greatly appreciated.

Jman · #2 26th February 2006, 06:24 AM

This seems to me to be the most important line:

Code:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

For some reason it's not finding the MySQL bindings. Your Class loading statment is exactly the same as your test class?

Coenos · #3 3rd April 2006, 11:21 AM

Hi,

I have the same problem but then with the Oracle drivers. I added the JDBC drivers to the common/lib, shared/lib and <application>/WEB-INF/lib and nothing works.....

In your post you mention you have set the CLASSPATH in your Tomcat startup script. Which script is that and where is it located, as I have not done that config myself.

Thanks,
Coen