ClassNotFoundException com.mysql.jdbc.Driver [duplicate]

Question

This question might have asked here number of times . After doing some google search for the above error and doing some update, I can't understand why I'm still getting that error. I've already put my driver-- mysql-connector-java-5.1.5-bin in the classpath:

Java_Home\jre\lib\ Java_Home\jre\lib\ext\ Java_Home\lib 

and the code which I'm using to connect to mysql database is:

try{ Class.forName("com.mysql.jdbc.Driver");  Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mail","root","");  Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select message_body from deadletter"); String dbtime; while (rs.next()) { dbtime = rs.getString(1); System.out.println(dbtime); }   con.close();  } catch (SQLException e) {         System.out.println("Connection Failed! Check output console");         e.printStackTrace();         }      } 

and the complete stacktrace of the above exception is:

java.lang.ClassNotFoundException: com.mysql.jdbc:Driver     at java.net.URLClassLoader$1.run(URLClassLoader.java:200)     at java.security.AccessController.doPrivileged(Native Method)     at java.net.URLClassLoader.findClass(URLClassLoader.java:307)     at java.lang.ClassLoader.loadClass(ClassLoader.java:307)     at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)     at java.lang.ClassLoader.loadClass(ClassLoader.java:252)     at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)     at java.lang.Class.forName0(Native Method)       at java.lang.Class.forName(Class.java:169)     at mail.main(mail.java:114)   

Now, what's wrong I'm doing here?

Answer 1

If you're facing this problem with Eclipse, I've been following many different solutions but the one that worked for me is this:

1. Right click your project folder and open up Properties.

2. From the right panel, select Java Build Path then go to Libraries tab.

3. Select Add External JARs to import the mysql driver.

4. From the right panel, select Deployment Assembly.

5. Select Add..., then select Java Build Path Entries and click Next.

6. You should see the sql driver on the list. Select it and click first.

And that's it! Try to run it again! Cheers!

Answer 2

I too struggled with the same problem and finally got the solution for it. Just copy the MySql-Connector.jar into Tomcat's lib folder, and then remove the jar from the webapp's lib folder, and then, run the project.