Re: java.sql.SQLException: The server time zone value 'EDT'

[Zhenlei Huang]

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.