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

最新推荐文章于 2022-10-01 20:25:11 发布
原创 最新推荐文章于 2022-10-01 20:25:11 发布 · 219 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文详细解析了在使用JDBC连接MySQL时遇到的时区错误问题，并提供了有效的解决方案，通过在连接URL中添加serverTimezone参数，成功解决了时间显示不准确的问题。

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


 

  1. 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.

  2. 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.

  3. 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.

  4. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127)

  5. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)

  6. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87)

  7. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61)

  8. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71)

  9. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)

  10.  
  11.  

  12. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)

  13. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)

  14. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)

  15.  
  16.  

  17. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)

  18. at java.sql.DriverManager.getConnection(Unknown Source)

  19. at java.sql.DriverManager.getConnection(Unknown Source)

  20. at zhu.jdbc.unit.UnitMysql.getConnection(UnitMysql.java:34)

  21. at zhu.jdbc.dao.imp.ITb_UserImpI.insertData(ITb_UserImpI.java:55)

  22. at zhu.jdbc.dao.imp.ITb_UserImpI.insertData(ITb_UserImpI.java:1)

  23. at zhu.jdbc.service.imp.ITb_UserServiceImpI.insertData(ITb_UserServiceImpI.java:35)

  24. at zhu.jdbc.service.imp.ITb_UserServiceImpI.insertData(ITb_UserServiceImpI.java:1)

  25. at zhu.jdbc.servlet.Servlet_TbUser.Insert(Servlet_TbUser.java:87)

  26. at zhu.jdbc.servlet.Servlet_TbUser.doPost(Servlet_TbUser.java:41)

  27. at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)

  28. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

  29. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

  30. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

  31. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

  32. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

  33. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

  34. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)

  35. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

  36. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)

  37. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

  38. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)

  39. at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)

  40. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

  41. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)

  42. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)

  43. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

  44. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)

  45.  
  46.  

  47. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)

  48. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

  49. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

  50. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

  51. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

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

  53. 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.

  54. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

  55. at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

  56. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

  57. at java.lang.reflect.Constructor.newInstance(Unknown Source)

  58. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)

  59. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:83)

  60. at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:128)

  61. at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2201)

  62. at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2225)

  63. at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1391)

  64. at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:993)

  65. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:852)

  66. ... 36 more

  67. 五月 15, 2018 9:38:04 下午 org.apache.catalina.core.StandardWrapperValve invoke

  68. 严重: Servlet.service() for servlet [Servlet_TbUser] in context with path [/myweb2] threw exception

  69. java.lang.NullPointerException

  70. at zhu.jdbc.dao.imp.ITb_UserImpI.insertData(ITb_UserImpI.java:59)

  71. at zhu.jdbc.dao.imp.ITb_UserImpI.insertData(ITb_UserImpI.java:1)

  72. at zhu.jdbc.service.imp.ITb_UserServiceImpI.insertData(ITb_UserServiceImpI.java:35)

  73. at zhu.jdbc.service.imp.ITb_UserServiceImpI.insertData(ITb_UserServiceImpI.java:1)

  74. at zhu.jdbc.servlet.Servlet_TbUser.Insert(Servlet_TbUser.java:87)

  75. at zhu.jdbc.servlet.Servlet_TbUser.doPost(Servlet_TbUser.java:41)

  76. at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)

  77. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

  78. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

  79. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

  80. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

  81. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

  82. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

  83. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)

  84. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

  85. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)

  86. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

  87. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)

  88. at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)

  89. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

  90. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)

  91. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)

  92. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

  93. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)

  94. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)

  95. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

  96. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

  97. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

  98. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

  99.  

  100. 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

      问题就会解决；

解决：Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone valu
simple的博客
06-01 3万+
报错信息为: Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure eith...
解决mysql报错The server time zone value ‘Öйú±ê׼ʱ¼ä‘ is unrecognized or represents.../服务器时区值无法识别
ABC的博客
10-19 5479
解决MySQL数据库服务器时区值无法识别问题
MySql数据库时区异常，java.sql.SQLException: The server time zone value '?й???׼ʱ?' is unrecognized or repr...
weixin_30647065的博客
03-20 311
JDBC访问MySql异常 Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:### Error querying database. Cause: java.sql.SQLException: The server time zone value '?й???׼ʱ?' is u...
使用JDBC出现The server time zone value问题解决方案
weixin_59459853的博客
10-01 346
ion in thread "main" java.sql.SQLException: The server time zone value
【SpringBoot】java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized
象在舞的技术专栏
05-15 571
SpringBoot项目中调用了MySQL数据库的数据，结果在查询数据的时候报了如下的错误： java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or represents more than one time zone. You must configure either the s...
在JDBC使用的时候有时候会出现java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or
胡乱选一个
08-31 325
原文出处:[https://blog.csdn.net/weixin_37577564/article/details/80329775]
springboot启动报错 Cause:java.sql.SQLException: The server time zone value ‘Öйú±ê׼ʱ¼ä‘ is unrecognize
weixin_45577058的博客
08-27 788
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
com.mysql.cj.exceptions.InvalidConnectionAttributeException: 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. 如何解决
最新发布
03-08
总结下来，解决方案应该分步骤，首先建议在JDBC连接字符串中添加serverTimezone参数，如果不行，再指导如何修改MySQL服务器的时区配置。同时，提供检查当前时区的方法，以及注意事项，如驱动版本和时区名称的正确性...
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 ...
myBatis 异常：java.sql.SQLException: The server time zone value ‘???ú±ê×??±??‘ is unrecognized or
qq1359236225的博客
03-16 155
异常：java.sql.SQLException：服务器时区值’???ú±ê×??±??'是未被认可的，或表示多个时区。 解决方法：在 url后面加上 ?serverTimezone=GMT
问题处理——java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or ...
小黑王HK
09-20 1934
错误信息截图   错误信息 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 ...
java访问数据库，报错提示：java.sql.SQLException: The server time zone value ‘???ú±ê×??±??‘ is unrecognized or
钢铁直女
03-30 352
错误提示1： java.sql.SQLException ：服务器时区值’???ê×?? ?? ??” 无法识别或代表多个时区。如果要利用时区支持，则必须配置服务器或JDBC驱动程序（通过serverTimezone配置属性）以使用更具体的时区值。在com.mysql.cj.jdbc.exceptions。 SQLError.createSQLException（SQLError.java:127）在com.mysql.cj.jdbc.exceptions.SQLError.createSQLExcepti
java.sql.SQLException: The server time zone value
06-28 3659
springboot 整合mybatis 时候报错 配置 datasource: username: root password: root driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://127.0.0.1:3306/blog?useSSL=false&requireSSL=false&characterEncoding=UTF-8&serverTimezone=Asia/S
解决java.sql.SQLException: The server time zone value ‘?й???????‘ is unrecogniz
weixin_47341383的博客
10-29 2763
The server time zone value ‘?й???’ is unrecogniz 解决方法 在配置数据库URL后面加上serverTimezone=GMT%2B8 //添加代码 serverTimezone=GMT%2B8 图片展示：
Javaweb项目中出现java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized or represe...
bangluoo351772的博客
08-13 921
javaweb项目中java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. 异常，如下图： 服务器时区值“？？？？±××？±？无法识别或代表一个以上的时区。如果希望利用时区支持，则必须配置服务器或JD...
java.sql.SQLException: The server time zone value ‘???ú±ê×??±??‘ is unrecognized or ...
小方的博客
06-10 723
mysql
java.sql.SQLException: The server time zone value ‘???ú±ê×??±??‘
weixin_45750855的博客
10-13 2342
问题描述 在Tomcat的环境下java web项目，页面传参到对应servlet的时候报错 java.sql.SQLException: The server time zone value ‘???ú±ê×??±??’ is unrecognized or represents more than one time zone. 问题解决 在JDBC或者yml配置数据库链接url处加上 &serverTimezone=UTC 使之成为如下形式： 时区设置完毕，异常解决。 ..
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值