无法加载驱动程序类:com.mysql.jdbc.Driver Spring [英] Cannot load driver class: com.mysql.jdbc.Driver Spring

问题描述

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

即使定义了驱动程序类名称，我仍然会收到此错误

im getting this error even with the driver-class-name difined

java.lang.IllegalStateException:无法加载驱动程序类: com.mysql.jdbc.Driver位于 org.springframework.util.Assert.state(Assert.java:392) 〜[spring-core-4.2.1.RELEASE.jar:4.2.1.RELEASE]在 org.springframework.boot.autoconfigure.jdbc.DataSourceProperties.getDriverClassName(DataSourceProperties.java:153) 〜[spring-boot-autoconfigure-1.3.0.M5.jar:1.3.0.M5]在 org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration $ NonEmbeddedConfiguration.dataSource(DataSourceAutoConfiguration.java:119) 〜[spring-boot-autoconfigure-1.3.0.M5.jar:1.3.0.M5]在 sun.reflect.NativeMethodAccessorImpl.invoke0(本机方法) 〜[na:1.8.0_60]在 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 〜[na:1.8.0_60] at ......

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 ......

然后继续

推荐答案

如果您使用的是Maven，请将其添加到您的pom.xml:

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

(推荐)供MySQL 5.6, 5.7, 8.x和Java >= 8使用；

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

(旧版)供MySQL <= 5.5或Java <= 7或JDBC < 4.2使用；

(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.48</version>
</dependency>

有关Connector/J版本的详细信息

这篇关于无法加载驱动程序类:com.mysql.jdbc.Driver Spring的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！