java - spring boot 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

我认为您需要在 spring.datasource.url = ... 行的 application.properties 中添加 ?serverTimezone=IST

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