You must configure either the server or JDBC driver (via the serverTimezone configuration property)
问题描述
Failedjava.sql.SQLException: The server time zone value ‘Coordinated Universal Time’ 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.
主要是JDBC驱动的时区设置和server端的时区设置不一致的问题。
解决方法
在db连接串后面加上:?serverTimezone=UTC,解决时区问题。完整示例:jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC【可以指定时区问题】
扩展
在db连接串后面加上:?useUnicode=true&characterEncoding=UTF-8,完整示例:jdbc:mysql://localhost:3306/dbname?useUnicode=true&characterEncoding=UTF-8 【可以解决中文乱码问题】
当然也可以联合起来用jdbc:mysql://localhost:3306/dbname?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC