[DERBY-6920] Add input support for new date and time classes

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Abandoned
• Component/s: JDBC
• Flags: Patch
• Assignee: Unassigned
• Reporter: Philippe Marschall
• Created: 22/Jan/17 12:30
• Updated: 24/May/24 07:49
• Resolved: 24/May/24 07:49

Description

This is the first half of DERBY-6445. The patch adds support for the new date and time classes for input only. I may add output support later but for now splitting it up makes for a smaller, easier to review and implement patch.

A couple of notes about the implementation:

• as the project now requires Java 1.8 I added the code directly to the classes
• the existing tests are expanded
• I avoided calling the provided #valueOf conversion methods for several reasons:
  • LocalTime has nanosecond resolution but java.sql.Time only has millisecond resolution
  • LocalDateTime can represent timestamps that can not be represented by java.sql.Timestamp because they fall into a daylight saving time transition
  • Performance should be much better since creating a DateTimeValue instance is a simple matter of calling a few getters. No calculation or object creation is involved.

Issue Links

• relates to: DERBY-6445 JDBC 4.2: Add support for new date and time classes