skip to main content
DataDirect Connect Drivers : PostgreSQL Driver : Connection Properties
  
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:
* AccountingInfo
* AlternateServers
* ApplicationName
* BulkLoadBatchSize
* CatalogOptions
* ClientHostName
* ClientUser
* ConnectionRetryCount
* ConnectionRetryDelay
* ConvertNull
* Database
* DatabaseName
* EnableCancelTimeout
* EncryptionMethod
* HostNameInCertificate
* ImportStatementPool
* InitializationString
* InsensitiveResultSetBufferSize
* JavaDoubleToString
* KeyPassword
* KeyStore
* KeyStorePassword
* LoadBalancing
* LoginTimeout
* MaxLongVarcharSize
* MaxNumericPrecision
* MaxNumericScale
* MaxPooledStatements
* MaxStatements
* MaxVarcharSize
* Password
* PortNumber
* ProgramID
* QueryTimeout
* ResultSetMetaDataOptions
* ServerName
* SpyAttributes
* SupportsCatalogs
* TransactionErrorBehavior
* TrustStore
* TrustStorePassword
* User
* ValidateServerCertificate
* VarcharClobThreshold