openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim Holloway (JIRA)" <>
Subject [jira] Created: (OPENJPA-638) Timestamp unsuitable for versioning on PostgreSQL databases
Date Thu, 19 Jun 2008 17:53:45 GMT
Timestamp unsuitable for versioning on PostgreSQL databases

                 Key: OPENJPA-638
             Project: OpenJPA
          Issue Type: Bug
          Components: docs
         Environment: PostgreSQL ca Version 8, Section 2.17 of the Apache OpenJPA User's Guide.
            Reporter: Tim Holloway

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.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message