当JDBC遇到MySQL8.

最新推荐文章于 2024-07-23 22:18:24 发布

灬Dan灬

最新推荐文章于 2024-07-23 22:18:24 发布

阅读量290

点赞数

CC 4.0 BY-SA版权

分类专栏：各种问题

本文链接：https://blog.youkuaiyun.com/qq_41448891/article/details/82875110

各种问题专栏收录该内容

14 篇文章

订阅专栏

本文详细解析了在使用MySQL数据库时遇到的时区配置错误，包括错误原因、堆栈跟踪及解决方案。介绍了如何正确配置serverTimezone参数，避免因时区设置不当导致的连接失败。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mmp整整一晚上就因为技术更新的快,而我李刚大佬的书相较老,就总是读不出数据
以前加载驱动 "com.mysql.cj.jdbc.Driver"
现在加载驱动方式
"com.mysql.cj.jdbc.Driver"
以前的url
url="jdbc:mysql://localhost:3306/test;
现在的url
url="jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=GMT";
useSSL是让你选择是否加密校验,后面是让你设置时区.
一般来说的错误原因

连接数据库失败
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)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:832)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
	at ConnectMySql.ConnMySql.main(ConnMySql.java:21)
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: 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 java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:488)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
	at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:128)
	at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2236)
	at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2260)
	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1314)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:963)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
	... 6 more
Exception in thread "main" java.lang.NullPointerException
	at ConnectMySql.ConnMySql.main(ConnMySql.java:30)