MySQL Connector/J 6.x jdbc.properties 配置, mysql-connector-java-6.0.4.jar 异常
报错信息
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.
出现原因:
因为使用了Mysql Connector/J 6.x以上的版本,然后就报了时区的错误
解决方案:
### MySQL Connector/J 5.x (旧版连接) #jdbc.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8 ### MySQL Connector/J 6.x (新版连接) jdbc.url=jdbc:mysql:///test?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false
于此同时,驱动也建议使用新版驱动
#数据库驱动
### MySQL Connector/J 5.x (旧版连接
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
### MySQL Connector/J 6.x (新版连接)
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver