java.sql.SQLException: The server time zone value 。。。的解决办法 - 好文

关于这个问题，是在使用Activiti的时候遇到的，如下图：

具体内容如下：

Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error getting a new connection. Cause: 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.
### Cause: 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
org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.getConnection(DefaultSqlSession.java:300)
at
org.activiti.engine.impl.db.DbSqlSession.isTablePresent(DbSqlSession.java:1011)
... 38 more
Caused by: 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
org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:201)
at
org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:196)
at
org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:93)
at
org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:385)
at
org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:89)
at
org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:138)
at
org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:60)
at
org.apache.ibatis.session.defaults.DefaultSqlSession.getConnection(DefaultSqlSession.java:298)
... 39 more
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)

... 52 more

问题分析：

由错误信息可知：无法检查表是否已经使用元数据显示，在创建表的时候，不能正常连接，在往下看，The server time zone value
，关于这个版本，在Mysql服务的新版中种最为常见，因为我使用的环境为最新的MySLQ社区版8.0.11
<https://download.csdn.net/download/hello_world_qwp/10417433>
，在新版的数据库使用的时区与本地时区有区别，标准时区使用的是Unix元年的时间为起始点到当前时间中间所做的动作。国际标准失去与本地相差 8 个小时。

解决办法：

经过上面的问题分析后，该问题的解决办法有两种；

一种：通过修改数据库变量实现，如下图：

二种：在连接MySQL服务时，直接指定时区为UTC，即可，将原来的连接

jdbc:mysql://000.000.000.000:3306/etc?useUnicode=true&characterEncoding=utf8

改为现在的：

jdbc:mysql://000.000.000.000:3306/etc?serverTimezone=UTC

更改后如下图：

注意：UTC一定要大写，否则无效！！！

解决完成后，再次连接MySQL数据库服务器，成功连接了，如下图：

好了，关于 java.sql.SQLException: The server time zone value
。。。就写到这儿了，如果还有什么疑问或遇到什么问题欢迎扫码提问，可以给我留言。
歇后语：“ 共同学习，共同进步 ”，也希望大家多多关注CSND的IT社区。

热门工具换一换