September 26th, 2001, 06:43 AM
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...
org.apache.jasper.JasperException: Unable to compile class for JSP
Any help is much appreciated.
October 8th, 2001, 12:10 PM
I had the same problem and this is how i fixed it.
you need to uncompress the jar file by doing
This will uncompress the file archive into something like
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.