You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "Mark Struberg (Jira)" <ji...@apache.org> on 2021/04/01 15:02:00 UTC

[jira] [Created] (OPENJPA-2854) fix OffsetTime handling for PostgreSQL

Mark Struberg created OPENJPA-2854:
--------------------------------------

             Summary: fix OffsetTime handling for PostgreSQL
                 Key: OPENJPA-2854
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2854
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 3.1.2
            Reporter: Mark Struberg
            Assignee: Mark Struberg
             Fix For: 3.1.3


PostgreSQL doesn't natively support OffsetTime. While it has a column type {{time with time zone}} it actually only stores the time as UTC time.

On the JDBC level we need to use {{java.sql.Time}} with the servers local offset. The rest will be converted automatically inside the JDBC driver.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)