SQLException之serverTimeZone

• 使用mysql connector java连接数据库驱动

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>6.0.6</version>
</dependency>

在升级到最新版本后需要注意的几个问题

• 旧的驱动类过期，提供了一个新的驱动类，替换并不影响其他操作

//旧的过期驱动
com.mysql.jdbc.Driver
//新提供的驱动类
com.mysql.cj.jdbc.Driver

• ServerTimeZone配置会抛出异常

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.

在配置url连接时需要指定时区的概念，如下：

url=jdbc:mysql://localhost/test?serverTimeZone=UTC