Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

The server time zone value 'CDT' is unrecognised or represents more than one time zone.

Reason: This error comes from the JDBC driver. The driver obtains a three-letter time zone code. These three-letter codes have been deprecated, and some of the codes, such as "CDT," are ambiguous. In this case, "CDT" could refer to "Central Daylight Time" or "Cuba Daylight Time", so this code is not a valid time zone identifier.

  1. Add the “serverTimezone“ parameter to the JDBC URL in the $Tomcat_Dir/conf/context.xml file as below.

Example of the serverTimezone setting in context.xml file.

"jdbc:mysql://HOST:PORT/DATABASE?serverTimezone=America/New_York"

2. Restart the Tomcat service

 

Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com