com.mysql.jdbc.Driver not found

Question

I am using eclipse for creating servlets. I downloaded the mysql-connector-java-5.0.8-bin.jar (connector/j) and added the jar file to build path of my project. I can use the classes in mysql-connector-java-5.0.8-bin.jar (IDE gives me hints and all that stuff and there is no problem using those classes in compile time) . but when i run the servlet i get this error:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

It sounds like suddenly the com.mysql.jdbc.Driver class that i've been using can not be found!

When i use the jar file for java SE projects it works perfect but it doesn't work with javaEE. How can i fix this?

Not build path, you need to add it as the runtime classpath. — evanwong, Jul 03 '14 at 15:33
@evanwong thanks. it worked. i would really appreciate it if you could post this as the answer so other people can use it... — Gandalf, Jul 03 '14 at 16:03

score 1 · Accepted Answer · answered Jul 03 '14 at 16:12

1

The database connector jar should be set as the runtime classpath instead of the build paths since database driver is a runtime dependency.

answered Jul 03 '14 at 16:12

evanwong

5,054
3
31
44

score 0 · Answer 2 · answered Jul 03 '14 at 15:34

0

Drop the jar into the WEB-INF/lib folder.
WEB-INF/lib folder is for application specific jars.
You could also use your servlet container's common/lib folder for jars which are common to several web applications.

answered Jul 03 '14 at 15:34

Teddy

4,009
2
33
55

com.mysql.jdbc.Driver not found

2 Answers2