JavaBug系列- Failed to load driver class com.mysql.cj.jdbc.Driver in either of HikariConfig class load

Java医生

本系列记录常见Bug，以及诊断过程和原因
Java/一对一零基础辅导/企业项目一对一辅导/日常Bug解决/代码讲解/毕业设计等

V:study_51ctofx

一、关于错误信息

APPLICATION FAILED TO START

---

Description:

Failed to bind properties under ‘’ to com.zaxxer.hikari.HikariDataSource:

Property: driver-class-name
Value: com.mysql.cj.jdbc.Driver
Origin: "driverClassName" from property source "source"
Reason: Failed to load driver class com.mysql.cj.jdbc.Driver in either of HikariConfig class loader or Thread context classloader

启动SpringBoot项目失败，配置datasource如下：

spring:
  application:
    name: item-service
  datasource:
    url: jdbc:mysql://localhost:3306/heima
    username: root
    password: root
    

通过以上信息分析，应用程序试图加载com.mysql.cj.jdbc.Driver，但是失败了；

思路: 该驱动是新版mysql的连接方式，需要引入新版本的mysql驱动，查看自己pom引用的版本

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

可以看到版本是5.1.32，版本过低，应该升级新的驱动版本

二、如何解决问题

解决方式一：修改版本8.0.11

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

解决方式二：指定spring datasource配置的driver-class-name为旧版的连接驱动类

spring:
  application:
    name: item-service
  datasource:
    url: jdbc:mysql://localhost:3306/heima
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver

Java题库在线答题：www.51ctofx.com