ClassNotFoundException with com.mysql.cj.jdbc.Driver, MySQL Connector and IntelliJ IDEA

user_2642983 0
Viewed 36089

I'm building up a Maven Java 1.8 project in which I've included the MySQL Connector as a dependency:

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

In my application I've a singleton that holds the MySQL connection so when the application starts, the MySQL connector is triggered but I got a ClassNotFoundException for the driver that I'm using: com.mysql.cj.jdbc.Driver.

The JDBC URL that I'm using is:

jdbc:mysql://localhost:3306/mydb?autoReconnect=true&useSSL=false

I'm using IntelliJ IDEA (2017.2) IDE.

I've checked in File -> Project Structure -> Libraries -> I see "Maven: mysql:mysql-connector-java:5.1.392" as a Library.

I've also checked under File -> Project Structure -> Artifacts -> and under myapp.war exploded -> WEB-INF -> lib -> Maven: mysql:mysql-connector-java:5.1.39 is present.

From View -> Tool Windows -> Database, I've succesfully made a MySQL connection dowloading the suggested driver (MySQL Connector 5.1.35).

How can I tell the application that it has to load the MySQL driver at runtime?

Thanks in advance

classnotfoundexception mysql-connector maven jdbc intellij-idea
6 Answers
user_75151860

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!

user_117429300

Just Do ItDownload Mysql Driver

Download Mysql Driver bY php storm IDE No Need to download manually

user_84506030

Alternatively you can load the mysqlconnector/j.jar file to the \lib\ext folder in the path where you installed the jre.

user_136203940
Related