22.  PostgreSQL

22.1. Known issues with PostgreSQL

Example 2.22.  Example properties for PostgreSQL

openjpa.ConnectionDriverName: org.postgresql.Driver
openjpa.ConnectionURL: jdbc:postgresql://SERVER_NAME:5432/DB_NAME

22.1.  Known issues with PostgreSQL

  • Floats and doubles may lose precision when stored.

  • PostgreSQL cannot store very low and very high dates.

  • Empty string/char values are stored as NULL.

  • Persistent fields of type java.io.Reader are not supported when using LOB streaming.