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

Timestamp unsuitable for versioning on PostgreSQL databases

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • docs
    • None
    • PostgreSQL ca Version 8, Section 2.17 of the Apache OpenJPA User's Guide.

    Description

      PostgreSQL can store objects in its native timestamp in a format determined by PostgreSQL build options. By default, the postgresql timestamp is a double-precision floating-point number with maximum precision of 6 digits (see section 8.4 of the PostgreSQL 8.2.7 documentation). java.sql.Timestamp extends java.util.Date, and thus stores data in long integer milliseconds. The resulting value mismatch can cause optimistic updates to fail.

      See also Jira issue OpenJPA-636.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              timh Tim Holloway
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated: