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

    Join Date
    Aug 2001
    Posts
    1
    Rep Power
    0

    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:
    Code:
    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
    Posts
    10
    Rep Power
    0
    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

IMN logo majestic logo threadwatch logo seochat tools logo