23.  PostgreSQL

23.1. Known issues with PostgreSQL

Example 2.23.  Example properties for PostgreSQL

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

23.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.

  • UUID support allows usage of binary data on entities. If the user wants to exchange String for UUID, it is necessary to previously convert the String to UUID type in database.