4

There is a similar question here but regarding the class path. ClassNotFoundException com.mysql.jdbc.Driver

I've had everything working great until some days ago. Suddenly my little application can't find the mysql driver. And i don't understand why (really I've checked everything)

I got the driver jar in the WEB-INF/lib, but tomcat just seems unable to find it.

Anyone got any ideas why? I'm using Ubuntu with tomcat 6 and mysql installed from the synaptics packadge manager

The error that is giving is:

ClassNotFoundException: com.mysql.jdbc.Driver

I've even changed the permissions into 777 to see if it could be invisibile, but it isn't :(

Community
  • 1
  • 1
fmsf
  • 36,317
  • 49
  • 147
  • 195
  • 1
    The colon in the message "com.mysql.jdbc:Driver" is not what I'd expect to see. Is that for real, or a typing error? – Stephen C Nov 14 '09 at 03:29
  • 1
    typing error, i was copying this by hand from another computer. – fmsf Nov 14 '09 at 03:40
  • How are you trying to create a datasource? From within your application or from a JNDI bound connection pool (DBCP)? – cherouvim Nov 14 '09 at 09:14

4 Answers4

7

If you created a datasource which requires this driver, then it should be placed directly in the classpath of the container which manages the datasource. In this case, it's Tomcat which manages the datasource. Thus, with placing the driver in Tomcat/lib you'll be fine.

Apart from that, you told you're using Ubuntu. It ships by default with a GNU JDK. I would only highly recommend that you ensure that you get rid of it and install the Sun JDK instead. The GNU JDK is cluttered of bugs which may cause at first sight unexplainable problems. Hope you take this into consideration.

BalusC
  • 1,082,665
  • 372
  • 3,610
  • 3,555
  • I changed it and now it finds the driver in web-inf/lib ty – fmsf Nov 14 '09 at 19:04
  • CATALINA_HOME is more appropriate than "Tomcat" to avoid confusion with CATALINA_BASE. Also, the reference to buggy GNU JDK, while certainly valid at the time of writing, does no longer apply (although Oracle JDK vs OpenJDK is debatable but that's another topic). – youri Aug 16 '13 at 12:26
5

Try putting the MySQL JDBC driver in $CATALINA_HOME/lib and restart the web server. Also, make sure the tomcat user (or whatever user you are running tomcat as) has permissions to read it.

Asaph
  • 159,146
  • 25
  • 197
  • 199
0

Download "mysql-connector-java-5.1.13-bin.jar" from following link http://sqlworkbench.mgm-tp.com/viewvc/trunk/sqlworkbench/junit/mysql-connector-java-5.1.13-bin.jar?revision=2294&pathrev=2294 and copy it to "Tomcat/lib" folder ie..."$CATALINA_HOME/lib" folder and restart Tomcat

Fathah Rehman P
  • 8,401
  • 4
  • 40
  • 42
0

Add the jar file in tomcat lib. I think you can delete the jar file from application's WEB-INF/lib, because then there might be two definitions for one class. So just copy the jar file in tomcat lib. hope this helps. :)

Senthil Kumar
  • 9,695
  • 8
  • 36
  • 45