Ubuntu + Tomcat5.5 + MySQL connector driver

urban

Hello,

I've been spending the whole day on a CLASSPATH problem with my Tomcat5.5 install on ubuntu :

I've installed:
apt-get install sun-java6-jdk sun-java6-jre tomcat5.5 libmysql-java

I set : TOMCAT5_SECURITY=no
in /etc/default/tomcat5.5
because of access right errors with Birt (the reporting tool I intend to run)

I expected the mysql-connector JAR driver installed thanks to libmysql-java, but I get the following trace in catalina.log :
SEVERE: DriverClassLoader failed to load class: com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

I'm pretty sure I didn't put the driver in the right folder, but I cannot figure out where to put it !
Wherever I put the mysql-connector JAR file, I get the same error.

If I look at the default installed driver, I see :
-rw-r--r-- 1 root root 679777 2008-07-31 14:53 /usr/share/java/mysql-connector-java-5.1.6.jar
lrwxrwxrwx 1 root root 30 2009-06-02 22:39 /usr/share/java/mysql-connector-java.jar -> mysql-connector-java-5.1.6.jar

Thanks in advance for your help

JasonW

If you are getting this error with BIRT put the driver in the jdbc plugins drivers directory. You can also set the driver patch using the appcontext if you need it somewhere else.

config.getAppContext().put("OdaJDBCDriverClassPath", "c:/birt/mysql/mysql-connector-java-5.0.4-bin.jar");

in a report beforeOpen script:
reportContext.getAppContext().put("OdaJDBCDriverClassPath", "c:/birt/mysql/mysql-connector-java-5.0.4-bin.jar");

Jason