java.sql.SQLException: The server time zone value '?й???????' is unrecognized or represents more
来源:互联网 发布:中国空军臂章淘宝 编辑:程序博客网 时间:2024/06/07 06:31
异常信息:
2017-09-11 10:57:05,595 ERROR [com.alibaba.druid.pool.DruidDataSource] - create connection error, url: jdbc:mysql://172.16.2.10:3306/dadao?useUnicode=true&characterEncoding=utf-8, errorCode 0, state 01S00
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:545)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:505)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:479)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:489)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:69)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1606)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:633)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:219)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149)
at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:217)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1466)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1529)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2239)
Caused by: com.mysql.cj.core.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.GeneratedConstructorAccessor26.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)
at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
at com.mysql.cj.jdbc.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:118)
at com.mysql.cj.mysqla.MysqlaSession.configureTimezone(MysqlaSession.java:293)
at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:2399)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1739)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1596)
... 9 more
上述环境
druid :1.1.3 , jdbc driver:6.0.6 ,mysql :5.7.16
程序链接数据库属性配置
jdbc.type=mysql
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://172.16.2.10:3306/dadao?useUnicode=true&characterEncoding=utf-8
后修改成:
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://172.16.2.10:3306/dadao?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&serverTimezone=Asia/Shanghai
无此错误。
原因分析:这是由于数据库和系统时区差异所造成的,在jdbc连接的url后面加上serverTimezone,还有就是降低Mysql驱动版本
- 异常:java.sql.SQLException: The server time zone value '?й???????' is unrecognized or represents more
- java.sql.SQLException: The server time zone value '?й???????' is unrecognized or represents more
- 解决mysql java.sql.SQLException: The server time zone value‘XXXXXX' is unrecognized or represents...
- 解决mysql java.sql.SQLException: The server time zone value‘XXXXXX' is unrecognized or represents...
- 解决mysql java.sql.SQLException: The server time zone value‘XXXXXX' is unrecognized or represents...
- java.sql.SQLException: The server time zone value '�й���ʱ��' is unrecognized or represents more tha
- The server time zone value 'EDT' is unrecognized or represents more than one time zone.
- Mysql错误:The server time zone value is unrecognized or represents more than one time zone
- The server time zone value 'PDT' is unrecognized or represents more than one time zone
- The server time zone value '?泄???????' is unrecognized or represents more t
- mysql出现错误:The server time zone value is unrecognized or represents more than one time zone
- bug: The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone.
- 连接数据库:ERROR: The server time zone value '�й�' is unrecognized or represents more than one time zone
- The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone.
- The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You mu
- The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You mu
- The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You m
- 数据库连接 The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone.
- Bloom Filter
- Open vSwitch Datapath浅析
- js事件委托
- Fragmemt组件及穿透等
- Shader学习之Cg语言二(Cg数据类型)
- java.sql.SQLException: The server time zone value '?й???????' is unrecognized or represents more
- 从零开始搭建MongoDB数据库即服务
- extern "C"的使用介绍
- jQuery动态添加删除select项(实现代码)
- 从脚本编写到面向对象的 Python 编程
- java验证码显示
- 如何将Oracle 当前日期加一天、一分钟
- 使用tensorflow serving 启动模型时,报如下错误:The TensorFlow library wasn't compiled to use SSE4.1 instructions
- python 隐藏平方级__字符串