ClassNotFoundException 'com.mysql.jdbc.Driver'

Question

I got this error when I use Class.forName[...]. I used the JConnector MSI Installer (http://dev.mysql.com/downloads/connector/j/5.1.html) so I got no ZIP file to add to my build path or I don't know where the installer put it.

Any ideas?

You can get the file from here : http://www.java2s.com/Code/Jar/m/Downloadmysqlconnectorjar.htm — Shiladittya Chakraborty, Oct 21 '15 at 08:19
I don't know where the installer put it. It didn't show a directory and immediatly closed after finishing the installation. — Dyrdek, Oct 21 '15 at 08:23
I want to connect to a XAMPP MySQL Database. And the server is a Apache. — Dyrdek, Oct 21 '15 at 08:50
You can always just choose "other platforms" and download the zip version containing the jar. Its an odd choice of Oracle to only offer the msi download when you pick windows as the platform. — Gimby, Oct 21 '15 at 08:54
Possible duplicate of [ClassNotFoundException com.mysql.jdbc.Driver](http://stackoverflow.com/questions/1585811/classnotfoundexception-com-mysql-jdbc-driver) — duffy356, Oct 21 '15 at 08:55

Shiladittya Chakraborty · Accepted Answer · 2015-10-21T08:53:24.560

1

Try to insert this:

DriverManager.registerDriver(new com.mysql.jdbc.Driver());

before getting the JDBC Connection.

Other option :

1: Download the mysql-connector-java.jar

2: You need to drop JAR in /WEB-INF/lib folder.

3: properties of project->build path->add JAR and selected the JAR above.

edited Oct 21 '15 at 08:53

answered Oct 21 '15 at 08:27

Shiladittya Chakraborty

4,270
8
45
94

Which server you are using? – Shiladittya Chakraborty Oct 21 '15 at 08:48
Apache, and I'm using XAMPP if this is kind of helpful. – Dyrdek Oct 21 '15 at 08:51
Thanks! I created the project as a Dynamic Web Project and follow your instructions with the /WEB/INF/lib and the build path ;) Works! – Dyrdek Oct 21 '15 at 09:15

ClassNotFoundException 'com.mysql.jdbc.Driver'

1 Answers1