My Oracle Support Banner

UCP 23.3 Version Driver Inserting DATE With Wrong Timestamp (Doc ID 3051833.1)

Last updated on OCTOBER 04, 2024

Applies to:

JDBC - Version 23.2 to 23.4 [Release 23]
Universal Connection Pool - Version 23.3 and later
Information in this document applies to any platform.

Symptoms

While testing with JDBC, UCP libraries it was reported that oracle DATE column has wrong timestamp values.
API LocalDate.now() to populate date values from java code, however when applied UCP 23.5 patch issues seems to be fixed.
UCP 23.3 --> 30-AUG-2024 12:00:00

UCP 23.5 --> 30-AUG-2024 00:00:00

The problem is present in version 23.2.0.0 and 23.3.0.23.09 of ojdbc11.jar, and is not present in 21.11.0.0 and earlier.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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