똑같은 삽질은 2번 하지 말자

The server time zone value '???' is unrecognized or represents more than one time zone. 본문

Spring/Spring Boot

The server time zone value '???' is unrecognized or represents more than one time zone.

곽빵 2020. 4. 20. 16:16

java.sql.SQLException: The server time zone value 'KST' is unrecognized or represents more than one time zone.

 

mysql-connector-java 버전 5.1.X 이후 버전부터 KST 타임존을 인식하지 못하는 이슈가 있다고 합니다.

characterEncoding=UTF-8&serverTimezone=UTC parameter 값을 추가해주면 됩니다.

 

ex)

server.port = 8083

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/shop_db?characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root

 

 

 

 

 

 

 

 

 

 

'Spring > Spring Boot' 카테고리의 다른 글

Spring Boot 개념다지기 No.4  (0) 2020.04.24
Spring Boot 개념다지기 No.3  (0) 2020.04.21
Spring Boot 개념다지기 No.2  (0) 2020.04.19
Spring Boot 개념다지기 No.1  (0) 2020.04.18
MYSQLでページングをする時  (0) 2020.04.10
'Spring/Spring Boot' Related Articles more
Comments