JDBC中The server time zone value '???ú±ê×??±??' is ............. 的错误

最新推荐文章于 2024-07-02 08:36:07 发布
最新推荐文章于 2024-07-02 08:36:07 发布
阅读量7.2w 收藏 106
点赞数 87
分类专栏： JDBC
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_37577564/article/details/80329775
版权

    在JDBC使用的时候有时候会出现java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or represents........的错误，具体错误如下：

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.
Tue May 15 21:38:04 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
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:127)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)


	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)


	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at zhu.jdbc.unit.UnitMysql.getConnection(UnitMysql.java:34)
	at zhu.jdbc.dao.imp.ITb_UserImpI.insertData(ITb_UserImpI.java:55)
	at zhu.jdbc.dao.imp.ITb_UserImpI.insertData(ITb_UserImpI.java:1)
	at zhu.jdbc.service.imp.ITb_UserServiceImpI.insertData(ITb_UserServiceImpI.java:35)
	at zhu.jdbc.service.imp.ITb_UserServiceImpI.insertData(ITb_UserServiceImpI.java:1)
	at zhu.jdbc.servlet.Servlet_TbUser.Insert(Servlet_TbUser.java:87)
	at zhu.jdbc.servlet.Servlet_TbUser.doPost(Servlet_TbUser.java:41)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)


	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)
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 sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:83)
	at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:128)
	at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2201)
	at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2225)
	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1391)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:993)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:852)
	... 36 more
五月 15, 2018 9:38:04 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [Servlet_TbUser] in context with path [/myweb2] threw exception
java.lang.NullPointerException
	at zhu.jdbc.dao.imp.ITb_UserImpI.insertData(ITb_UserImpI.java:59)
	at zhu.jdbc.dao.imp.ITb_UserImpI.insertData(ITb_UserImpI.java:1)
	at zhu.jdbc.service.imp.ITb_UserServiceImpI.insertData(ITb_UserServiceImpI.java:35)
	at zhu.jdbc.service.imp.ITb_UserServiceImpI.insertData(ITb_UserServiceImpI.java:1)
	at zhu.jdbc.servlet.Servlet_TbUser.Insert(Servlet_TbUser.java:87)
	at zhu.jdbc.servlet.Servlet_TbUser.doPost(Servlet_TbUser.java:41)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

	at java.lang.Thread.run(Unknown Source)

       出现这个的原因是因为 mysql返回的时间总是有问题，比实际时间要早8小时。

解决办法
public static final  String URL="jdbc:mysql://localhost:3306/jdbc01?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";//链接的mysql

        在jdbc连接的url后面加上serverTimezone=GMT即可解决问题，如果需要使用gmt+8时区，需要写成GMT%2B8

      问题就会解决；

shlxll
关注
专栏目录
解决mysql报错The server time zone value ‘Öйú±ê׼ʱ¼ä‘ is unrecognized or represents.../服务器时区值无法识别
ABC的博客
10-19 5127
解决MySQL数据库服务器时区值无法识别问题
springboot启动报错 Cause:java.sql.SQLException: The server time zone value ‘Öйú±ê׼ʱ¼ä‘ is unrecognize
weixin_45577058的博客
08-27 686
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userMapper' defined in file [D:\学习课程\S4\s4_谷粒在线教育项目\day01_进行mybatis_plus的进阶学习\code\mybatis-plus-demo\target\classes\com\liujie\mybatisplus\mapper\UserMapper.cl
JDBC连接M有SQL数据库报错The server time zone value '???ú±ê×??±??' is unrecognized or represents........
默默的博客
07-16 6473
利用JDBC连接数据时，会报错误具：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 s...
MySQL Server时区支持
最新发布
u011565038的博客
07-02 1165
本文介绍MySQL维护的时区设置——如何加载命名时间支持所需的系统表，如何及时了解时区变化，以及如何启用闰秒支持。
jdbc数据库连接出现The server time zone value
qq_41971768的博客
11-12 279
MySQL版本与驱动不匹配问题 MySQL5.7以下版本 ---- mysql-connector-java 5.x.x MySQL5.7以上版本 ---- mysql-connector-java 8.0.21 注意： 8.0 的驱动类路径：com.mysql.cj.jdbc.Driver 5.0 的驱动类路径：com.mysql.jdbc.Driver 低版本数据库使用高版本驱动时会产生错误：The server time zone value
使用JDBC连接MySql时出现：The server time zone value 的问题
傲世狂少
09-03 793
具体场景： 服务器安装Mysql8.0.20 原来使用的jdbc驱动为mysql5.1，为了更好的性能和匹配度，就改为myql8.0.20jdbc驱动。 更换驱动后要注意修改dirveClassName 原来的低版本驱动名称为：com.mysql.jdbc.Driver 新驱动名称为： jdbc.driverClassName =com.mysql.cj.jdbc.Driver 启动应用，结果在连接数据库过程中出现如下错误： The server time zone value...
JDBC连接数据库时出现The server time zone value '???ú±ê×??±??' .........错误
Allen8523的博客
03-20 2087
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 ...
JDBC报错The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than a time zone.
樂小伍
08-25 656
【JDBC报错，具体如下】---- 是因为URL中没有设置时区 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 dri...
The server time zone value '???ú±ê&times;??±??' 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.
06-03
这个错误通常是因为MySQL...useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC ``` 其中，`serverTimezone`参数指定了服务器时区，可以根据需要更改为适当的时区。
The server time zone value 'Öйú±ê&times;¼Ê±¼ä' is unrecognized or represents more than one time zone.
09-19
MySQL默认的时区是美国的时＊＊＊的URL后面加上serverTimezone=GMT+8，示例：jdbc:mysql://localhost:3306/springbootdemo?serverTimezone=GMT+8 方法二：在MySQL中设置时区为系统所在时区（推荐）：mysql> set ...
解决MySQL连接时异常InvalidConnectionAttributeException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unreco
Peacock__的博客
02-22 2096
详细报错信息 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 serverTimez...
使用JDBC连接数据库出现The server time zone value '�й���׼ʱ��' is解决方案
大西瓜不甜的博客
03-20 2963
将jdbc.properties中url后加入?serverTimezone=UTC即可解决** // 原驱动 driverClass=com.mysql.cj.jdbc.Driver url=jdbc:mysql://localhost:3306/stus //更改为 driverClass=com.mysql.cj.jdbc.Driver url=jdbc:mysql://loc...
JDBC出现“The server time zone value ‘�й���׼ʱ��‘ is unrecognized or represents more than one time” 解决
Eternity_he的博客
02-05 534
MySQL8.0连接时需要加上时区：serverTimezone=UTC。
使用JDBC出现The server time zone value问题解决方案
weixin_59459853的博客
10-01 255
ion in thread "main" java.sql.SQLException: The server time zone value
The server time zone value ‘�й���׼ʱ��‘ is unrecognized or represents more than one time zone
热门推荐
gao_zhennan的博客
04-04 3万+
不仅告诉你解决问题的方法，同时会介绍在mysql中为什么要配置时区，以及如何配置时区
java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or represents mor
a599174211的博客
11-09 803
使用的数据库是MySQL和驱动都是8.0.11连接数据库需要做如下修改 1.  加载类“com.mysql.jdbc.Driver”。这已被弃用。新的驱动程序类是`com.mysql.cj.jdbc.Driver'。 jdbc.driverClass=com.mysql.jdbc.Driver修改为 jdbc.driverClass=com.mysql.cj.jdbc.Driverr ...
什么比日期和时区更难？ SQL / JDBC中的日期和时区！
最佳 Java 编程
05-29 150
在jOOQ邮件列表上，最近有一个有趣的讨论，关于jOOQ当前缺乏对TIMESTAMP WITH TIME ZONE数据类型的现成支持。 没有人说日期，时间和时区很容易！ 这里有一个有趣的部分，我建议阅读： 虚假的程序员相信时间 当那还不够时，还请阅读： 更多的虚假程序员相信时间 我个人喜欢程序员错误地认为“ Unix时间是自1970年1月1日以来的秒数”。 …Unix时间无法代表...
使用jdbc链接数据库问题出现time zone
qq_18096915的博客
03-31 442
报错1：Caused by: java.sql.SQLException: The server time zone value 原因：系统与数据库链接出现的时间差问题（UTC表示国际时区） 解决：jdbc.url=jdbc:mysql://localhost:3306/库名serverTimezone=UTC&characterEncoding=utf-8 或者serverTimezone=GMT%2B8 （中国时区） : ...
评论 72
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

shlxll

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值