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

by

It seems the mysql connectivity library is not included in the project. Solve the problem following one of the proposed solutions:

  • MAVEN PROJECTS SOLUTION

Add the mysql-connector dependency to the pom.xml project file:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.39</version>
</dependency>

Here you are all the versions: https://mvnrepository.com/artifact/mysql/mysql-connector-java

  • ALL PROJECTS SOLUTION

Add the jar library manually to the project.

Right Click the project — > build path — > configure build path

In Libraries Tab press Add External Jar and Select your jar.

You can find zip for mysql-connector here

  • Explanation:

When building the project, java throws you an exception because a file (the com.mysql.jdbc.Driver class) from the mysql connectivity library is not found. The solution is adding the library to the project, and java will find the com.mysql.jdbc.Driver

More Related Contents:

  1. Is it safe to use a static java.sql.Connection instance in a multithreaded system?
  2. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  3. MySQL JDBC Driver 5.1.33 – Time Zone Issue
  4. How to connect to Oracle using Service Name instead of SID
  5. Java ResultSet how to check if there are any results
  6. Retrieve column names from java.sql.ResultSet
  7. JDBC connection failed, error: TCP/IP connection to host failed
  8. How can I get the SQL of a PreparedStatement?
  9. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  10. Is java.sql.Connection thread safe?
  11. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  12. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  13. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  14. How does Java’s PreparedStatement work?
  15. Create a jTDS connection string
  16. How to get all table names from a database?
  17. JDBC Pagination
  18. Should I use java.util.Date or switch to java.time.LocalDate
  19. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  20. Queries returning multiple result sets
  21. java error (No suitable driver found)
  22. Cannot use a LIKE query in a JDBC PreparedStatement?
  23. How can I abort a running JDBC transaction?
  24. How to Correctly Close Resources
  25. PreparedStatement with Statement.RETURN_GENERATED_KEYS
  26. How to get row count using ResultSet in Java?
  27. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  28. java sql date time
  29. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  30. Java JDBC connection status

Leave a Comment