Notice
Recent Posts
Recent Comments
Tags more
«   2024/12   »
일 월 화 수 목 금 토
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31
Archives
Today
Total
관리 메뉴

웹개발자의 기지개

[Spring Boot] java.sql.SQLException: The server time zone value '´ëÇѹα¹ Ç¥ÁؽÃ' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver - time zone 에러 본문

Java/Spring Boot

[Spring Boot] java.sql.SQLException: The server time zone value '´ëÇѹα¹ Ç¥ÁؽÃ' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver - time zone 에러

http://portfolio.wonpaper.net 2023. 7. 31. 14:03

 

 

1
2
3
4
5
6
7
java.sql.SQLException: The server time zone value '´ëÇѹα¹ Ç¥ÁؽÃ' 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.
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127) ~[mysql-connector-java-8.0.11.jar:8.0.11]
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) ~[mysql-connector-java-8.0.11.jar:8.0.11]
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87) ~[mysql-connector-java-8.0.11.jar:8.0.11]
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61) ~[mysql-connector-java-8.0.11.jar:8.0.11]
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71) ~[mysql-connector-java-8.0.11.jar:8.0.11]
 
 cs

 

jdbc:mysql://localhost:3306/spring?characterEncoding=UTF-8&verifyServerCertificate=false&useSSL=false&serverTimezone=UTC

 

 

 

참고 : https://devuna.tistory.com/47

 

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

[Spring Boot] STS 상에서 클릭시 jsp 파일이 메모장이나 기타 다른 연결프로그램으로 열릴때  (0) 2023.11.15
[Spring Boot] redirect 시 parameter 값 넘기기  (0) 2023.09.30
[Spring Boot] Mysql8 에러 - WARN: Establishing SSL connection without server's identity verification is not recommended.  (0) 2023.07.31
[Spring Boot] mysql8 에러 - WARN: Establishing SSL connection without server's identity verification is not recommended.  (0) 2023.07.31
[Spring Boot] java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) 에러해결하기  (0) 2023.07.31
'Java/Spring Boot' Related Articles more
Comments