ClassNotFoundException : com.mysql.jdbc.Driver but it's in the classpath

Question

I have this Exception but the Jar file are in the referenced libraries.

I dont't know where is the problem. The code is alright and I have added all in the build path. String DRIVER_CLASS_NAME = "com.mysql.jdbc.Driver";

final String DBMS = "jdbc:mysql";

final String SERVER="localhost";

final String DATABASE = "mapDB";

final int PORT=3306; 

final String USER_ID = "MapUser";

final String PASSWORD = "map";

Connection conn;//gestisce una connessione 

private void initConnection() throws DatabaseConnectionException {
    try {
        Class.forName(DRIVER_CLASS_NAME);/
    }catch(ClassNotFoundException e) {
        e.printStackTrace();
    }

    try {

        conn=(Connection)DriverManager.getConnection(DBMS + "://" + SERVER + ":" + PORT + "/" + DATABASE,USER_ID,PASSWORD);
    }catch(SQLException ex) {
        throw new DatabaseConnectionException();
    }
}

Andreas · Accepted Answer · 2018-05-31 21:55:42Z

1

Your image shows you have mysql-connector-java-5.1.7-bin.jar on your classpath.

When looking for that file in the Maven Repository, there are many 5.1.x versions, but not 5.1.7.

It would seem that 5.1.7 is flawed and have been retracted.

Try using another 5.1.x version, e.g. the latest, which currently is 5.1.46.

answered May 31, 2018 at 21:55

Andreas

160k13 gold badges164 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matheus Canon · Accepted Answer · 2018-05-31 21:09:16Z

0

It appears that there are different versions of MySQL JDBC connectors, as the second print shows.

Maybe the existence of 2 references to the same lib is causing the ClassNotFoundException, or your project's build is not up to date.

I suggest you to keep only one version of the connector on the references of your project, clear and build the project again.

answered May 31, 2018 at 21:09

Matheus Canon

1252 silver badges9 bronze badges

3 Comments

Sante Altamura Over a year ago

Yes. But I realized I had another project that has the same String DRIVER_CLASS_NAME and do the same thing. Is this the problem?

Matheus Canon Over a year ago

I don't think so. Maybe changing the reference order on the classpath can solve this. Try putting the connector reference up on the classpath, like in this print: i.sstatic.net/zjqPr.png

Matheus Canon Over a year ago

Also, if you're using Maven or Gradle, try to build the project on the command line, like: mvn clean install.

Anshul Khandelwal · Accepted Answer · 2018-05-31 21:13:04Z

0

Have you tried removing mysql-connector-java-5.1.7-bin.jar, just keep mysql-connector-java-8.0.11.jar

answered May 31, 2018 at 21:13

Anshul Khandelwal

1188 bronze badges

2 Comments

Sante Altamura Over a year ago

Yes. But I realized I had another project that has the same String DRIVER_CLASS_NAME and do the same thing. Is this the problem? I must remove this project from eclipse? There is another solution?

Anshul Khandelwal Over a year ago

If you keep both version then you have to check you import statements: import java.sql.DriverManager; import java.sql.SQLException; import com.mysql.jdbc.Connection; and import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; since in version 8.0.11 Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver'. T

Collectives™ on Stack Overflow

ClassNotFoundException : com.mysql.jdbc.Driver but it's in the classpath

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related