23. PostgreSQL
Prev | Appendix 2. Supported Databases | Next

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

Prev | Up | Next
22. Pointbase | Home | 24. IBM solidDB