Exception in thread “main“ java.sql.SQLException: The server time zone value ‘ÖÐ¹ú±ê×¼Ê±¼ä‘

最新推荐文章于 2023-07-11 15:48:30 发布

披着虎皮的汤姆猫

最新推荐文章于 2023-07-11 15:48:30 发布

阅读量598

点赞数 1

CC 4.0 BY-SA版权

分类专栏：问题

原文链接：https://blog.youkuaiyun.com/weixin_38888926/article/details/89476144

问题专栏收录该内容

2 篇文章

订阅专栏

本文介绍了使用JDBC连接MySQL数据库时出现的时间配置错误及SSL握手异常问题，并提供了两种解决方案：一是通过设置服务器时区参数，二是禁用SSL连接。

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

刚学jdbc遇到的问题

Exception in thread "main" 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.

错误为系统时间错误

只需要在访问数据库的Url后面加上以下的语句即可：

?serverTimezone=GMT%2B8

或者

&serverTimezone=UTC

例如URL为：

jdbc:mysql://localhost:host/data01

改为

jdbc:mysql://localhost:host/data01?serverTimezone=GMT%2B8

加过之后运行成功输出结果但出现了这个问题

** BEGIN NESTED EXCEPTION ** 

javax.net.ssl.SSLException
MESSAGE: closing inbound before receiving peer's close_notify

STACKTRACE:
javax.net.ssl.SSLException: closing inbound before receiving peer's close_notify
	at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:133)
	at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:117)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:311)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:267)
	at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:258)
	at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:801)
	at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(SSLSocketImpl.java:780)
	at com.mysql.cj.protocol.a.NativeProtocol.quit(NativeProtocol.java:1319)
	at com.mysql.cj.NativeSession.quit(NativeSession.java:182)
	at com.mysql.cj.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:1750)
	at com.mysql.cj.jdbc.ConnectionImpl.close(ConnectionImpl.java:720)
	at jdbc.jdbc01.main(jdbc01.java:15)

解决办法就是在URL的后面加上&useSSL=false

jdbc:mysql://localhost:host/data01?serverTimezone=GMT%2B8&useSSL=false

原文：https://blog.youkuaiyun.com/qq_34075488/article/details/85106860