Connection Properties
This section lists the JDBC connection properties supported by the PostgreSQL driver and describes each property. The properties have the form:
property=value
You can use these connection properties with either the JDBC Driver Manager or DataDirect Connect Series for JDBC data sources unless otherwise noted.
Note: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such.
Note: The data type listed for each connection property refers to the Java data type used for the property value in a JDBC data source.
The following table provides a summary of the connection properties supported by the PostgreSQL driver and their default values.
Table 54. PostgreSQL Driver Properties
Property | Default |
| None |
| None |
| empty string |
| 1000 (rows) |
| 2 |
| empty string |
| empty string |
| 5 |
| 1 (second) |
| 1 (data type check is performed if column value is null) |
| None |
| None |
| false |
| noEncryption |
| empty string |
| empty string |
| None |
| 2048 (KB of memory) |
| false |
| None |
| None |
| None |
| false |
| 0 (no timeout) |
| 0 (driver’s internal prepared statement pooling is not enabled) |
| 1,073,741,823 |
| 1000 |
| 998 |
| 0 (driver’s internal prepared statement pooling is not enabled) |
| 10,485,760 |
| None |
| 5432 |
| empty string |
| 0 (query does not time out) |
| 0 (no additional processing to determine the correct table name for each column in the result set) |
| None |
| None |
| false |
| RollbackTransaction |
| None |
| None |
| None |
| true |
| 32768 |
This section includes the following topics: