calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Hyde (JIRA)" <>
Subject [jira] [Created] (CALCITE-1630) Support java.time values, per JDBC 4.2, and also Joda-Time
Date Fri, 10 Feb 2017 20:01:42 GMT
Julian Hyde created CALCITE-1630:

             Summary: Support java.time values, per JDBC 4.2, and also Joda-Time
                 Key: CALCITE-1630
             Project: Calcite
          Issue Type: Bug
          Components: avatica
            Reporter: Julian Hyde

JDK 8 introduced the java.time package (based on [Joda-Time|]),
and JDBC 4.2. The core JDBC interface is still based on the broken/confusing java.sql.Date,
java.sql.Time, java.sql.Timestamp types, but has some support for java.time types:
* Instant is analogous to java.sql.Timestamp but has no direct mapping to a SQL type;
* Duration is somewhat similar to SQL's INTERVAL type;
* LocalDateTime is analogous to SQL's TIMESTAMP type;
* java.time.OffsetDateTime is analogous to SQL's TIMESTAMP WITH TIME ZONE type.

Also, we should support the same behavior on the corresponding Joda-Time types. (But let's
do it without making Avatica depend on a particular version of Joda-Time. Could we use reflection
and do it without adding Joda-Time as a dependency?)

See [an article about adding this support for PostgreSQL|].

This message was sent by Atlassian JIRA

View raw message