Spring boot配置数据源报错之java.sql.SQLException和java.sql.SQLNonTransientConnectionException

最新推荐文章于 2025-06-26 19:40:27 发布

pandalovey

最新推荐文章于 2025-06-26 19:40:27 发布

阅读量6.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： Exception 文章标签： Spring boot

本文链接：https://blog.youkuaiyun.com/pandalovey/article/details/83957765

Exception 专栏收录该内容

2 篇文章

订阅专栏

本文记录了使用Springboot整合Mybatis过程中遇到的两个常见数据库连接问题：时区设置错误导致的java.sql.SQLException异常，以及因连接字符串格式不正确引发的java.sql.SQLNonTransientConnectionException异常。通过在数据库配置中正确设置serverTimezone属性和修正连接字符串中的语法错误，成功解决了上述问题。

周末想自己用Spring boot整合Mybatis写点简单的demo，没想到出了点以前没遇到过的bug，特记录一下

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=UTC"即可

java.sql.SQLNonTransientConnectionException: Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near ';characterEncoding=utf-8&useSSL=false&serverTimezone=UTC'.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[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:79) ~[mysql-connector-java-8.0.13.jar:8.0.13]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:131) ~[mysql-connector-java-8.0.13.jar:8.0.13]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:227) ~[mysql-connector-java-8.0.13.jar:8.0.13]

原因：无效的数据库连接地址，"&amp；"无法识别，直接用"&"连接数据库配置项目即可

修改后的application.yml配置如下：

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/testMybatis?useUnicode=true&amp;characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver