Re: java.sql.SQLException: The server time zone value 'EDT'
Posted by: Zhenlei Huang
Date: October 29, 2019 05:03AM

Hi Filipe Silva,

I'm encountering a similar problem with server time zone 'CST' (China Standard Time). After digging and debugging it looks in JVM 'CST' was mapped to 'America/Chicago', and thus saving wrong DATE / TIME / DATETIME / TIMESTAMP value into DB. It will be kind if MySQL Connector / J warns such situation, and documented with detail.

Further more, if the MySQL protocol, aka., OSI layer 7, transfer TIMESTAMP with timezone info, then it will be no longer necessary for the connector to processing server side timezone, no custom serverTimezone needed anymore.

What do you think about that?

THX.

Options: ReplyQuote


Subject
Written By
Posted
Re: java.sql.SQLException: The server time zone value 'EDT'
October 29, 2019 05:03AM


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.