访问mysql时设置时区

最新推荐文章于 2024-09-12 06:30:00 发布

转载最新推荐文章于 2024-09-12 06:30:00 发布 · 590 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/yqz/blog/861571

文章标签：

#数据库 #java #c#

为什么80%的码农都做不了架构师？>>>

使用DRUID访问mysql数据库时，程序出错：

Druid-ConnectionPool-Create-2721989 ERROR 2017-03-17 17:19:42:612 com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2001) create connection error, url: jdbc:mysql://localhost:3306/pet?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=false, 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:148)
   at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:211)
   at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)
   at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:785)
   at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38)
   at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)
   at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1427)
   at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1481)
   at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1998)
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.GeneratedConstructorAccessor22.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   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)
   ... 12 more