1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2001
    Rep Power

    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:
    org.apache.jasper.JasperException: Unable to compile class for JSP
    java.lang.NumberFormatException: mysql
    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.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2001
    Rep Power
    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


    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.

IMN logo majestic logo threadwatch logo seochat tools logo