CentOS 5:Tomcat and MySQL JDBC driver
 

I should be simple, but its driving me crazy.

I setup sun java jdk 1.6.0 update 27(the latest before version 7), installed tomcat via yum, and downloaded the latest version of the mysql jdbc driver and placed the jar file in /usr/share/tomcat5/common/lib. Everything I've read says this should work, yet the user's site thats using this isn't working and reports that it cannot find the driver.

javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver found

They are using JSTL and checking the code, looks good. I made a simple one that prints out the classpath, it shows the mysql jar.

So just for kicks I try out tomcat+jdk+mysql jdbc driver on my windows computer. Again the same problem. Any ideas? I've tried putting the mysql jar in different locations, the same result.

Hi,

I think that the correct location is /var/lib/tomcat5/common/lib

Regards

Maybe package unixodbc you need!?!?! Im sure you need that :)