After Applying the Patch 33727616, Default Handling of Time zones in Date/Time Values is Changed (Doc ID 2908127.1)

Last updated on APRIL 01, 2024

Applies to:

Goal

Default handling of Time zones in date/time values is changed in Connector/J 8.0. How to correct it?

While using SOA application with MySQL Server as database to insert date/time into one of the database field, it shows different values.

Driver used with 12.2.1.4 is mysql-connector-java-commercial-8.0.14.jar

After applying the patch 33727616, they noticed that it is converting datetime to -5 hours before inserting to DB

As this patch is superseeded by 34012040, tried with the new patch as well but still the same issue

If the patch is rollbacked , it is working fine.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.