Why do I get a timezone error when creating a database connection?
Last Updated: | Applicable Hub Versions: All
Last Updated: | Applicable Hub Versions: All
If you receive the below error when creating a database connection, you must add a server a serverTimezone parameter to your JDBC URL. For example: jdbc:mysql://hostname:13306/database_name?serverTimezone=America/New_York
The server timezone value '...' is unrecognized or represents more than one timezone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specific timezone value if you want to utilize timezone support.