Database JDBC and Timezone

Question

Wayne Choi 2020-2-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/504664-database-jdbc-and-timezone

评论： Wayne Choi 2020-7-13

I have encountered this problem while I am trying to connect to the database MySQL. My JDBC driver is mysql-connector-java-8.0.19.jar and I cannot configure ,jar file.

JDBC Driver Error: The server time zone value 'Mitteleurop�ische Zeit' 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.

May i know if there is any solution by setting up some command lines in Matlab to fix this problem instead of changing the content in .jar file and database? Thank you.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jemima Pulipati 2020-7-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/504664-database-jdbc-and-timezone#answer_463940

MySQL Driver 8.x has a backward incompatibility which requires the server to be configured with a time-zone which can be recognized correctly. 

Database Toolbox is not responsible for this behavior, instead it is the MySQL Driver which enforces this behavior causing issues. It would be best to check with the database administrator to find out the ServerTimeZone to provide as part of your database URL/ configure the server accordingly.

Alternatively, try Connector J Version 5.1 as this should also work with MySQL 8.0 Server:

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-versions.html