Details
Description
The mapping tool (openjpa:sql maven target) generates a column of type ABSTIME on Postgres 8.4. This is wrong because
1. ABSTIME is deprecated and
2. ABSTIME has a resolution of 1s.
It should be TIMESTAMP.
The workaround is to specify
<property name="openjpa.jdbc.DBDictionary" value="TimestampTypeName=TIMESTAMP" />
in your persistence.xml
Attachments
Issue Links
- is part of
-
OPENJPA-1726 Clean up OpenJPA test case failures for PostgreSQL
- Closed
- is related to
-
OPENJPA-1985 ClassCastException in max(Timestamp) function on PostgreSQL
- Closed