[PHOENIX-6881] Implement the applicable Date/Time features from JDBC 4.2

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.2.0, 5.1.3
• Fix Version/s: 5.2.0, 5.1.4
• Component/s: core
• Release Note: Phoenix now supports setting and retrieving java.time.LocalDate, java.time.LocalDateTime and java.time.LocalTime objects via the ResultSet.getObject() and PreparedStatement.setObject() APIs, as defined by JDBC 4.2
• Assignee: Istvan Toth
• Reporter: Istvan Toth
• Created: 16/Feb/23 12:43
• Updated: 11/May/23 04:34
• Resolved: 21/Mar/23 17:56

Description

https://jcp.org/aboutJava/communityprocess/maintenance/jsr221/JDBC4.2MR-January2014.pdf

This mosty means handling the java.time.Local* types in get/setObject.
The java.time.Offset types are probably not relevant to to Phoenix.

Java 8 includes JDBC 4.2, and the version of the spec is available at

https://download.oracle.com/otndocs/jcp/jdbc-4_2-mrel2-spec/

JDBC 4.3 is added in Java 9, but the changes there don't seem to be relevant to time handling.

Issue Links

• is depended upon by: PHOENIX-6882 Umbrella Ticket for date/time handling issues
• is related to: PHOENIX-5422 Use Java8 DateTime APIs instead of joda-time APIs
• split to: PHOENIX-6905 Add support for java.util.Calendar in JDBC getObject/setObject
• split to: PHOENIX-6915 Implement all conversions specified for ResultSet.getObject() and PreparedStatement.setObject() in JDBC 4.2
• links to: GitHub Pull Request #1571
• links to: GitHub Pull Request #1579