Re: java.sql.SQLException: The server time zone value 'EDT'
Posted by: Filipe Silva
Date: October 31, 2019 09:37AM

Hi Zhenlei,

Well, the thing with emit warnings about this is that we don't really know what people want. If we suddenly start doing it everyone in Central Standard Time will have a reason for complaining too.

WRT documentation, there is a note in Connector/J manual, in the upgrating to 8.0 section (https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-other-changes.html). I agree it could be better documented, though. It helps if you report a documentation bug against this manual in https://bugs.mysql.com/

The problem is that MySQL protocol doesn't support TIMESTAMP with time zone information. This is why we have to "align" these values somehow. Right now there is no alternative, I'm afraid.

IHTH

Options: ReplyQuote


Subject
Written By
Posted
Re: java.sql.SQLException: The server time zone value 'EDT'
October 31, 2019 09:37AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.