티스토리 뷰
SW개발/Database
com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'µµÄì Ç¥ÁؽÃ' is unrecognized or represents more than one time zone. You must configure either the server or JDBC
개소왕 2018. 5. 10. 23:40*
com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'µµÄì Ç¥ÁؽÃ' is unrecognized or represents more than one time zone. You must configure either the server or JDBC
* 해결
jdbc URL 에 serverTimeZone=UTC 추가
jdbc:mysql://192.168.123.130:3316/dbName?autoReconnect=true&useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
- hibernate 라면 hibernate.cfg.xml 과 root-context.xml 두군데 세션 팩토리 정의 부분에 추가
https://desty.github.io/2016/08/14/mysql-jdbc-timezone-issue
* 참고 : MySQL Timezone 설정
'SW개발 > Database' 카테고리의 다른 글
| WARN: Establishing SSL connection without server's identity verification is not recommended. (0) | 2018.07.06 |
|---|---|
| MySQL Timezone 설정 (2) | 2018.05.28 |
| SQL Error: 0, SQLState: 08S01 Communications link failure / (0) | 2018.05.10 |
| MySQL start job failed to start (0) | 2018.05.10 |
| MySQL 원격 접속 / ERROR 1410 (42000): You are not allowed to create a user with GRANT (3) | 2018.05.09 |