完整的报错是:
ERROR com.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:mysql:/xxxxx/xxxxx, 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.
原因是使用Mysql Connector/J 6.x以上的版本时,会提示这个时区的错误,在数据源配置时,在url后拼接?serverTimezone=UTC
即可,需要的话可以在通过以下方法更改指定编码格式。
useUnicode=true&characterEncoding=utf8//指定编码格式为utf8
此外报错的还有一个:
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.
这个很容易解决,将 ’com.mysql.jdbc.Driver‘替换为 'com.mysql.cj.jdbc.Driver’即可