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

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPENJPA-2854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17313228#comment-17313228 ] 

ASF subversion and git services commented on OPENJPA-2854:
----------------------------------------------------------

Commit c3bbb92557743928d045e1061360f3bfd48b182e in openjpa's branch refs/heads/master from Mark Struberg
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=c3bbb92 ]

OPENJPA-2854 fix OffsetTime handling for PostgreSQL

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.


> 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
>            Priority: Major
>             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)