Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello, First, the test used a JDBC connector from MySQL - mysql-connector-java-5.1.42-bin.jar.

Here is a typical connection in Base using this (local server - remote would be different address):

image description

Based on the info on this post -> How to change mysql timezone in java connection then added ?useLegacyDatetimeCode=false to the end of Datasource URL. Note, local time for server is PDT.

This resulted in a similar error to the one you received. Then, again based on the linked post, added to the end of last addition &serverTimezone=America/New_York and all worked OK. So the total additional info added was :

?useLegacyDatetimeCode=false&serverTimezone=America/New_York

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

Hello, Hello,

First, the test used a JDBC connector from MySQL - mysql-connector-java-5.1.42-bin.jar.

Here is a typical connection in Base using this (local server - remote would be different address):

image description

Based on the info on this post -> How to change mysql timezone in java connection then added ?useLegacyDatetimeCode=false to the end of Datasource URL. Note, local time for server is PDT.

This resulted in a similar error to the one you received. Then, again based on the linked post, added to the end of last addition &serverTimezone=America/New_York and all worked OK. So the total additional info added was :

?useLegacyDatetimeCode=false&serverTimezone=America/New_York

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.