Springboot + MySQL + Driver Class Not Found

Question

I'm doing a simple spring boot project with a thread pool and MySQL in order to connect to MySQL whenever I'm adding spring-boot-starter-jdbc I'm getting below error.

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Tomcat.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.tomcat.jdbc.pool.DataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver 
    at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:599) ~[spring-beans-4.3.14.RELEASE.jar:4.3.14.RELEASE]
    at org.s

Update 1:

    <dependencies>
            <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

<dependency>
    <groupId>com.opencsv</groupId>
    <artifactId>opencsv</artifactId>
    <version>3.3</version>
</dependency>

    </dependencies>

please share your pom.xml you might be missing the mysql jdbc driver dependency — Shubham Dixit
– Shubham Dixit, Commented Dec 27, 2018 at 10:39

oldborn · Accepted Answer · 2018-12-27 10:44:10Z

2

It seems like you are missing mysql-connector dependency, Add these to your pom.

Maven:

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

or gradle:

compile "mysql:mysql-connector-java:*"

answered Dec 27, 2018 at 10:44

oldborn

962 bronze badges

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

1 Comment

Swapnil Srivastav Over a year ago

I have added it

Vitalii Muzalevskyi · Accepted Answer · 2018-12-27 10:46:50Z

0

Looks like you forget to add dependency to MySQL (Spring Boot is using H2 database by default), you should add next lines to your pom.xml:

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

edited Dec 27, 2018 at 10:46

answered Dec 27, 2018 at 10:44

Vitalii Muzalevskyi

6728 silver badges18 bronze badges

1 Comment

Swapnil Srivastav Over a year ago

I have added mysql-connector-java

yeppe · Accepted Answer · 2018-12-27 10:53:02Z

0

First include this in your pom file.

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

Second, clean install the maven project. If you are using eclipse check your JDK version and maven (Sometime jre is used instead of jdk, so, though in console everything looks fine but acutally the jar is not downloaded) in short .m2 repo should have this jar file when maven build is done.

answered Dec 27, 2018 at 10:53

yeppe

6892 gold badges15 silver badges46 bronze badges

3 Comments

Swapnil Srivastav Over a year ago

at compile not I'm not getting error, I have used JdbcTemplate

Swapnil Srivastav Over a year ago

sure , give me the link

yeppe Over a year ago

stackoverflow.com/a/36079859/5086633 useful links .....stackoverflow.com/questions/28821521/…... also stackoverflow.com/questions/28042426/…

3EQn · Accepted Answer · 2018-12-27 10:57:19Z

0

Scope "runtime" is good for unit test and container as tomcat etc. when container provide jdbc driver. When run standalone apps (spring-boot) you should remove it or set to "compile".

answered Dec 27, 2018 at 10:57

3EQn

1391 gold badge6 silver badges23 bronze badges

5 Comments

3EQn Over a year ago

'mvn dependency:tree'

Swapnil Srivastav Over a year ago

I haven't install MAVEN locally

3EQn Over a year ago

You can execute this goal in ide. Which one you use?

Swapnil Srivastav Over a year ago

I'm using eclipse

Swapnil Srivastav Over a year ago

I can see all required Jars are there

Collectives™ on Stack Overflow

Springboot + MySQL + Driver Class Not Found

4 Answers 4

1 Comment

1 Comment

3 Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

3 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related