Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-6881

Implement the applicable Date/Time features from JDBC 4.2

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 5.2.0, 5.1.3
    • 5.2.0, 5.1.4
    • core
    • None
    • 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

    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.

      Attachments

        Issue Links

          is depended upon by

          Task - A task that needs to be done. PHOENIX-6882 Umbrella Ticket for date/time handling issues

          • Major - Major loss of function.
          • Open
          is related to

          Task - A task that needs to be done. PHOENIX-5422 Use Java8 DateTime APIs instead of joda-time APIs

          • Major - Major loss of function.
          • Patch Available
          split to

          New Feature - A new feature of the product, which has yet to be developed. PHOENIX-6905 Add support for java.util.Calendar in JDBC getObject/setObject

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. PHOENIX-6915 Implement all conversions specified for ResultSet.getObject() and PreparedStatement.setObject() in JDBC 4.2

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          links to

          Web Link GitHub Pull Request #1571

          Web Link GitHub Pull Request #1579

          Activity

            People

              stoty Istvan Toth
              stoty Istvan Toth
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: