弹簧引导 JDBC 无法识别服务器时区值'Jerusalem Standard Time'

Question

这是我第一次在spring-boot中使用jdbc，所以我遵循本指南：https://spring.io/guides/gs/accessing-data-mysql/

一切看起来都很好，直到我试图编译它，得到了这个错误：

The server time zone value 'Jerusalem Standard 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.

Answer 1

我认为您需要添加？serverTimezone=IST在您的application.properties的spring.datasource.url=。。。

spring.datasource.url=jdbc:mysql://localhost:3306/db_example?serverTimezone=IST