学习中问题记录

mysql新驱动引发的异常

2017-05-02  本文已影响0人  乌托邦缤果

org.activiti.engine.ActivitiException: couldn't check if tables are already present using metadata:

### 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

mysql使用mysql-connector-java 6.0.3/6.0.4 运行程序报异常

The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone.

原因:

数据库和系统时区差异造成

解决办法:

在jdbc连接的url后面加上serverTimezone=GMT或者UTC参数即可。

eg:

<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/activiti?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT
"/>

上一篇 下一篇

猜你喜欢

热点阅读