spring boot 默认的 mysql 驱动，出现 The new driver class is `com.mysql.cj.jdbc.Driver'

小灰灰 2022-04-16 05:17 449阅读 0赞

以前使用的是 5.1.31 的 mysql 驱动，后面使用 spring boot 默认的 mysql 驱动，就出现了一些异常。

异常如下（在 IDEA 上是一条红色的英文）：

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

按照提示，把 application.yml 改成如下：

spring:
      datasource:
        driver-class-name: com.mysql.cj.jdbc.Driver #com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/kaven
        username: kaven
        password: 015036
      jpa:
        hibernate:
          ddl-auto: update #更新
        show-sql: true

还是出现异常（异常前面几行）。

java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.13.jar:8.0.13]
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.13.jar:8.0.13]
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.13.jar:8.0.13]
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.13.jar:8.0.13]
    	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.13.jar:8.0.13]
    	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76) ~[mysql-connector-java-8.0.13.jar:8.0.13]

异常提示我们需要配置 serverTimezone ，因为我们本地服务器的时区值是未被认可或者表示多个时区。

所以把 application.yml 改成如下：

spring:
      datasource:
        driver-class-name: com.mysql.cj.jdbc.Driver #com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/kaven?serverTimezone=GMT
        username: kaven
        password: 015036
      jpa:
        hibernate:
          ddl-auto: update #更新
        show-sql: true

项目启动成功。

以下 serverTimezone 配置在我这里都能启动成功。

serverTimezone=GMT%2B8
    serverTimezone=GMT
    serverTimezone=Asia/Shanghai

参考博客：  
[com.mysql.jdbc.Driver 和 com.mysql.cj.jdbc.Driver的区别 serverTimezone设定][com.mysql.jdbc.Driver _ com.mysql.cj.jdbc.Driver_ serverTimezone]  
[JDBC中The server time zone value ‘???ú±ê×??±??’ is … 的错误][JDBC_The server time zone value _ is _]

[com.mysql.jdbc.Driver _ com.mysql.cj.jdbc.Driver_ serverTimezone]: https://blog.csdn.net/superdangbo/article/details/78732700
[JDBC_The server time zone value _ is _]: https://blog.csdn.net/weixin_37577564/article/details/80329775

spring boot 默认的 mysql 驱动，出现 The new driver class is `com.mysql.cj.jdbc.Driver'

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关解决：Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is ......

相关 MYSQL Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is `com.mysql.

相关 Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is `com.mysql.cj.jdb

相关 Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is`...

相关 spring boot 默认的 mysql 驱动，出现 The new driver class is `com.mysql.cj.jdbc.Driver'

相关关于Spring boot 集成mysql出现Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver cla

相关 Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdb

相关 SpringBoot项目常见异常：The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically

相关 Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdb

相关 Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdb