mm.mySQL JDBC problems

Hi im having problems with the mm.mySQL connector.

Apache 1.3.20 with ApacheJServ 1.1.2 is working properly.
Tomcat 4.0 is working properly.
mySQL 3.23.42 is working properly.

I downloaded mm.mysql-2.0.2.jar connector.
I placed it in my jdk/lib directory as mysql.jar.
I added C:\jdk\lib\mysql.jar to the CLASSPATH.

I used the JSP file from "Slapping Together A JSP Development Environment", configured it to the proper mySQL settings and point my browser to the JSP file. Here is the relavant error:


When I see this, I think there must be something wrong with the actual mysql.jar file. Or Tomcat, for whatever reason, cannot compile the file properly...

Any help is much appreciated.

I had the same problem and this is how i fixed it.

you need to uncompress the jar file by doing
cd path_to_jar_exe
jar name_of_jar_file


This will uncompress the file archive into something like

org
gjt
mm
mysql

and then inside the mysql directory will be a load of classes
i made a directory in /usr/java/java whatever/lib called mysqldrivers and copied the uncompressed directories into it. Then I set the classpath to the mysqldriver directory.
Winston