Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-2854

fix OffsetTime handling for PostgreSQL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.2
    • Fix Version/s: 3.2.0
    • Component/s: jdbc
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              struberg Mark Struberg
              Reporter:
              struberg Mark Struberg
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: