Re: java.sql.SQLException: The server time zone value 'EDT'
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
Subject
Written By
Posted
Re: java.sql.SQLException: The server time zone value 'EDT'
October 31, 2019 09:37AM
Sorry, you can't reply to this topic. It has been closed.
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.