Re: java.sql.SQLException: The server time zone value 'EDT'
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.
Subject
Written By
Posted
Re: java.sql.SQLException: The server time zone value 'EDT'
October 29, 2019 05:03AM
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.