Cannot load driver class: com.mysql.jdbc.Driver Spring [duplicate]

Question

spring.freemarker.cache:false

spring.datasource.url=jdbc:mysql://localhost/mydb
spring.datasource.username=user
spring.datasource.password=pass
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

I'm getting this error even with the driver-class-name defined:

java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver at org.springframework.util.Assert.state(Assert.java:392) ~[spring-core-4.2.1.RELEASE.jar:4.2.1.RELEASE] at org.springframework.boot.autoconfigure.jdbc.DataSourceProperties.getDriverClassName(DataSourceProperties.java:153) ~[spring-boot-autoconfigure-1.3.0.M5.jar:1.3.0.M5] at org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration$NonEmbeddedConfiguration.dataSource(DataSourceAutoConfiguration.java:119) ~[spring-boot-autoconfigure-1.3.0.M5.jar:1.3.0.M5] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_60] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_60] at ......

and it goes on

It simply means mysql dependency is missing in your pom file. Please add it then reload. — Elated Coder
– Elated Coder, Commented Sep 23, 2022 at 6:01

Mark Rotteveel · Accepted Answer · 2024-11-16 10:39:04Z

93

If you're using Maven, add this to your pom.xml:

(Recommended) For MySQL 5.6, 5.7, 8.x and Java >= 8 use:

<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <version>8.0.33</version>
</dependency>

(Legacy) For MySQL <= 5.5 or Java <= 7 or JDBC < 4.2 use;

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

More details on Connector/J versions

edited Nov 16, 2024 at 10:39

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

answered Oct 14, 2015 at 11:26

bekce

4,36033 silver badges31 bronze badges

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

2 Comments

voidcurser Over a year ago

<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.0.8</version> </dependency> already have this on mine too

aJaY Over a year ago

for java>=8, you can use as below in pom.xml

<dependency>       <groupId>com.mysql</groupId>       <artifactId>mysql-connector-j</artifactId>       <version>8.0.31</version>   </dependency>

Brijesh · Accepted Answer · 2019-01-27 14:27:45Z

15

It might be that you are using the deprecated driver class name. I solved it by updating the property in application.properties file.

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

edited Jan 27, 2019 at 14:27

answered Jan 27, 2019 at 14:09

Brijesh

3752 silver badges6 bronze badges

3 Comments

Arefe Over a year ago

It's not showing deprecated in the latest Spring version.

Brijesh Over a year ago

Yes, but its deprecated. For more details you can check below link dev.mysql.com/doc/connector-j/8.0/en/…

Mark Rotteveel Nov 16, 2024 at 10:40

While deprecated, the com.mysql.jdbc.Driver still exists, and can still be loaded. As such, this isn't a solution for the question.

Mark Rotteveel · Accepted Answer · 2024-11-16 10:43:49Z

Just confirm the following things.

If you are under proxy make sure use VPN to connect to internal servers, iif you are accessing DEV/STG servers

Make sure you add the following dependency inside correct location, like this

<dependencies> <--- inside this section
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.15</version>
    </dependency>
</dependencies>

and not in

<build> <--- Not this section
    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.15</version>
        </dependency>
    </dependencies>
</build>

And you don't need to use the following line
```
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
```
The spring.datasource.url=jdbc:mysql://xxxxx automatically know which driver to fetch.

I tried everything but your third point did it. I just deleted the datasource-driver line and everything went great. Thank you!

tyrantqiao · Accepted Answer · 2020-12-03 15:49:01Z

9

If you are using IDEA and maven, you might forget reloading all maven projects, which causes the dependencies don't have the MySQL connector jar. And that's why when u run the application, there will be the error remind "com.mysql.cj.jdbc.Driver".

edited Dec 3, 2020 at 15:49

answered Nov 8, 2020 at 7:25

tyrantqiao

3394 silver badges7 bronze badges

Comments

Dherik · Accepted Answer · 2018-07-05 14:16:39Z

I will share more causes of this error:

I already seen this error many times using Intellij IDEA and running some integration test. The test fail with the message: Caused by: java.lang.IllegalStateException: Cannot load driver class: org.h2.Driver. After rebuild the project (Build > Rebuild Project) the error disappears.
Another cause of this error is a corrupted JAR. A college was receiving this error (also trying to run integration tests) and, after delete some related jars on .m2 directory, the error was gone.

cegas · Accepted Answer · 2018-02-05 08:57:32Z

The crux of the problem is that you're missing MySQL driver dependency.

One of the ways, as outlined by other answers, is to specify it in your build tool's configuration. However, if you do not want to do it and are using IntelliJ IDEA (though I'm pretty sure Eclipse has something similar), you can also add the dependency via it. Steps:

Download desired jar from maven repository
Open your project in Intellij IDEA
File -> Project Structure -> Libraries
Click New Project Library (green plus sign on the left), or press Alt + Insert keys
Select Java
Select your jar
Press OK

Should look something like this:

Now you should be able to use the dependency you have just added.

Tested with IntelliJ IDEA 2017.3.4.

SatyaRajC · Accepted Answer · 2019-03-15 10:31:24Z

2

build.gradle

runtimeOnly 'mysql:mysql-connector-java'

application.yml

spring: 
    application:
        name: apevent
        version: 1.0
    datasource:
        driverClassName: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/applicaiton

answered Mar 15, 2019 at 10:31

SatyaRajC

518 bronze badges

2 Comments

stoneshishang Over a year ago

It's showing some command is deprecated so Gradle 8.0 can't run properly. so this answer is only for before Gradle 8.0

OneCricketeer Over a year ago

Should use implementation rather than runtimeOnly

Markus G. · Accepted Answer · 2017-09-11 17:43:42Z

1

Probably someone still needs an answer (as me before) I solved it by adding the following dependency

<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
</dependency>

answered Sep 11, 2017 at 17:43

Markus G.

1,7283 gold badges28 silver badges53 bronze badges

Comments

Arefe · Accepted Answer · 2019-02-06 07:45:20Z

1

I encountered the same problem now and solved it after providing the required dependency,

 <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.15</version>
    </dependency>

answered Feb 6, 2019 at 7:45

Arefe

12.6k25 gold badges133 silver badges197 bronze badges

Comments

PKS · Accepted Answer · 2021-07-08 06:52:26Z

0

adding the following dependency solved my issue

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

answered Jul 8, 2021 at 6:52

PKS

7811 gold badge9 silver badges23 bronze badges

Comments

Amos Machora · Accepted Answer · 2022-03-18 07:47:22Z

I know this might be a little late but maybe anyone from the future might find this answer helpful. This problem arises from potentially three reasons

Incorrect maven or Gradle configuration
Incorrect spring configuration in the application.properties file
Wrong class name on the application.properties file.
To troubleshoot if you are using maven. do not include the version name. This mostly is a recipe for problems, especially in huge applications. use maven autocompletes features to save you a little time.
configure the data source correctly. There are a lot of answers on it to this question. make sure it's correct. sometimes there is a cj that is missing or included where it's not supposed to be. Trial and error might help you discover the problem

if neither of the above options works. Remove spring.datasource.driver-class-name=com.mysql.jdbc.driver completely. I don't know if it magic but this last one worked for me.

GO NERDS!!!

Nguyễn Đức Khải · Accepted Answer · 2022-07-05 16:09:04Z

0

My problem is solved just by refresh the project, perhap the dependency did not load by the time you run the application

answered Jul 5, 2022 at 16:09

Nguyễn Đức Khải

112 bronze badges

2 Comments

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Japhei Over a year ago

This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. To get notified when this question gets new answers, you can follow this question. Once you have enough reputation, you can also add a bounty to draw more attention to this question. - From Review

Salami Korede · Accepted Answer · 2022-07-27 08:04:34Z

0

I had the same issue. It happened because I forgot to declare the MySQL connector dependency in my pom file. I added the dependency, then boom! The error went away.

answered Jul 27, 2022 at 8:04

Salami Korede

4295 silver badges10 bronze badges

Comments

Roman S · Accepted Answer · 2023-06-30 08:48:08Z

If you are using maven-shade-plugin to package your application in a fat jar, make sure you don't use its <minimizeJar>true</minimizeJar> option because this option will remove some classes from target jar. In my case it was the driver class and when I tried to deploy my app to k8s I got the error org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot load JDBC driver class 'oracle.jdbc.OracleDriver' because class was not present in my_fat_jar/oracle/jdbc folder.

Deovolente Mtavangu · Accepted Answer · 2024-11-16 10:19:26Z

0

if you are using IJ simple select the maven option on the right bar then use the refresh arrows, this will be solved . it worked perfectly on my side

answered Nov 16, 2024 at 10:19

Deovolente Mtavangu

1

Comments

stoneshishang · Accepted Answer · 2021-09-29 21:38:50Z

-1

For People who uses Gradle 8.0 and beyond. I had to use

implementation 'mysql:mysql-connector-java:8.0.26'

instead of

implementation group: 'mysql', name: 'mysql-connector-java', version: '8.0.26' ,

my application.yml looks like:

spring:
  datasource:
    driverClassName: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/<Your DB name>?useSSL=false

remember to reload your gradle file

answered Sep 29, 2021 at 21:38

stoneshishang

4515 silver badges11 bronze badges

Collectives™ on Stack Overflow

Cannot load driver class: com.mysql.jdbc.Driver Spring [duplicate]

16 Answers 16

2 Comments

3 Comments

1 Comment

Comments

Comments

Comments

2 Comments

Comments

Comments

Comments

Comments

2 Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

16 Answers 16

2 Comments

3 Comments

1 Comment

Comments

Comments

Comments

2 Comments

Comments

Comments

Comments

Comments

2 Comments

Comments

Comments

Comments

Comments

Linked

Related