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 |