JDBC告警系列(一)The server time zone value 'ÖÐ' is unrecognized or represents more than one time zone....
生活随笔
收集整理的這篇文章主要介紹了
JDBC告警系列(一)The server time zone value 'ÖÐ' is unrecognized or represents more than one time zone....
小編覺(jué)得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.
一、現(xiàn)象
java.sql.SQLException: The server time zone value '?D1ú±ê×?ê±??' 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.
很顯然,系統(tǒng)時(shí)區(qū)讀取時(shí)出現(xiàn)了錯(cuò)誤。
二、解決
方法1
可以在mysql中執(zhí)行命令: set global time_zone='+8:00'方法2
在數(shù)據(jù)庫(kù)驅(qū)動(dòng)的url后加上serverTimezone=UTC參數(shù)
jdbcUrl=jdbc:mysql://localhost:3306/omc?characterEncoding=utf8&serverTimezone=UTC?
轉(zhuǎn)載于:https://www.cnblogs.com/yoyotl/p/10458447.html
總結(jié)
以上是生活随笔為你收集整理的JDBC告警系列(一)The server time zone value 'ÖÐ' is unrecognized or represents more than one time zone....的全部?jī)?nèi)容,希望文章能夠幫你解決所遇到的問(wèn)題。
- 上一篇: Dart 2.2 发布,谷歌推出的结构化
- 下一篇: Firefox 65.0.2 发布,Fi