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?
-
Include the mysql.jar file in your build path.Shiladittya Chakraborty– Shiladittya Chakraborty10/21/2015 08:16:54Commented Oct 21, 2015 at 8:16
-
add mysql-connector-java-5.1.5-bin.jar in your classpathsoorapadman– soorapadman10/21/2015 08:17:55Commented Oct 21, 2015 at 8:17
-
You can get the file from here : java2s.com/Code/Jar/m/Downloadmysqlconnectorjar.htmShiladittya Chakraborty– Shiladittya Chakraborty10/21/2015 08:19:53Commented Oct 21, 2015 at 8:19
-
I don't know where the installer put it. It didn't show a directory and immediatly closed after finishing the installation.Dyrdek– Dyrdek10/21/2015 08:23:32Commented Oct 21, 2015 at 8:23
-
2Possible duplicate of ClassNotFoundException com.mysql.jdbc.Driverduffy356– duffy35610/21/2015 08:55:06Commented Oct 21, 2015 at 8:55
|
Show 3 more comments
1 Answer
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.
answered Oct 21, 2015 at 8:27
-
Which server you are using?Shiladittya Chakraborty– Shiladittya Chakraborty10/21/2015 08:48:35Commented Oct 21, 2015 at 8:48
-
Apache, and I'm using XAMPP if this is kind of helpful.Dyrdek– Dyrdek10/21/2015 08:51:31Commented Oct 21, 2015 at 8: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– Dyrdek10/21/2015 09:15:46Commented Oct 21, 2015 at 9:15