Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3611 Introduce TIME/TIMESTAMP WITH TIME ZONE types
  3. CALCITE-3615

Improve JDBC driver to support java.time classes

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • jdbc-adapter
    • None

    Description

      According to the JDBC spec (section B.6, page 198), columns of type TIMESTAMP WITH TIME ZONE should only be accessed via ResultSet.getObject() which should return a java.time.OffsetDatetime, however in practice many clients may not handle this type strictly according to spec.

      The choice of result-set getter method is up to the client, not the driver, and many clients may use getTimestamp or getString instead of getObject, so in practice this may or may not have a timezone, and we should support getTimestamp in the driver with proper timezone conversion for clients that prefer a java.sql.Timestamp for simplicity.

      Attachments

        Activity

          People

            Unassigned Unassigned
            docete Zhenghua Gao
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: