MySQL JDBC

[fparvini]

I wrote a small code for connection to MySQL trhough JDBC

<%@ page import="java.sql.*" %>

<%!
// mysql driver
String driver = "com.mysql.jdbc.Driver";

// the "url" to our DB, the last part is the name of the DB
String url = "jdbc:mysql://localhost/test";

// the default DB username and password may be the same as your control panel login

String name = "my_user";
String pass = "my_pass";
%>

<%

try
{
// Test the DB connection by making an empty table
String sql_command = "select * from test where id=1;";
Class.forName( driver );

// initialize the Connection, with our DB info ...
Connection con = DriverManager.getConnection( url, name, pass );

Statement stat = con.createStatement();

stat.executeQuery( sql_command );
%>


I have also downloaded mysql-connector-java-3.1.12.tar ,

Put it in /var/tomcat4/server/lib , changed /etc/rc.d/init.d/tomcat4 and added these lines to it

CLASSPATH=/var/tomcat4/server/lib/mysql-connector-java-3.1.10-bin.jar:$CLASSPATH
export CLASSPATH

and restart tomcat by /etc/rc.d/init.d/tomcat4 restart
but still get this error message


jdbc:mysql://localhost/test
Error opening JDBC, cause:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

 

[ktulur]

Just the same problem here.
It works out of the box with a standart tomcat setup....