Re: Unable to retrieve the timestamp field after upgrading to Mysql connector for java 8.0.30
This type of error is usually due to timezone differences.
To preserve the default behavior of Connector/J 8.0.22 to query the session time zone from the server and then convert a timestamp between that and the JVM time zone, set the new connection property connectionTimeZone to SERVER, and leave the other two new properties at their default values (i.e.,preserveInstants=true and forceConnectionTimeZoneToSession=false).
Users who had serverTimeZone=user-defined-time-zone and keep it the same, without configuring the new connection properties, can expect the same behavior as before, but testing is recommended.
If you have tried this, please provide your full jdbc connection string to see what options you have selected.
Subject
Written By
Posted
Re: Unable to retrieve the timestamp field after upgrading to Mysql connector for java 8.0.30
August 08, 2023 08:02PM
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.