This question already has an answer here:
JDBC connection error : unrecognized timezone [duplicate]
(1个答案)
去年关门了。
我正在尝试使用Spring工具套件在Spring Boot中连接到MySQL服务器。即使我的数据库正在运行并且架构已创建,我仍会收到以下错误:
我正在使用以下application.properties:
我不知道是什么引起了这个问题。
参考time-zone-issue
(1个答案)
去年关门了。
我正在尝试使用Spring工具套件在Spring Boot中连接到MySQL服务器。即使我的数据库正在运行并且架构已创建,我仍会收到以下错误:
WARN 44756 --- [ restartedMain] com.zaxxer.hikari.util.DriverDataSource : Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
ERROR 44756 --- [ restartedMain] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.
WARN 44756 --- [ restartedMain] o.s.b.a.orm.jpa.DatabaseLookup : Unable to determine jdbc url from datasource
WARN 44756 --- [ restartedMain] o.h.e.j.e.i.JdbcEnvironmentInitiator : HHH000342: Could not obtain connection to query metadata : The server time zone value 'PDT' 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.
WARN 44756 --- [ restartedMain] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
我正在使用以下application.properties:
spring.datasource.url=jdbc:mysql://localhost:3306/book-schema
spring.datasource.username=root spring.datasource.password=root1234
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.jpa.hibernate.ddl-auto=update
我不知道是什么引起了这个问题。
最佳答案
尝试在下面添加时区。
spring.datasource.url=jdbc:mysql://localhost:3306/book-schema?serverTimezone=UTC
参考time-zone-issue