This section lists the JDBC connection properties supported by the Progress OpenEdge 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 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 is 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 Progress OpenEdge driver and their default values.

Table 1. Progress OpenEdge Driver Properties
Property Default
AlternateServers None
CatalogOptions 2 (result sets contain synonyms)
ConnectionRetryCount 5
ConnectionRetryDelay 1 (second)
ConvertNull 1 (data type check is performed if column value is null)
CryptoProtocolVersion

No default value
Database None
DatabaseName None
EncryptionMethod noEncryption
FailoverGranularity nonAtomic
FailoverMode connect
FailoverPreconnect false
HostNameInCertificate empty string
ImportStatementPool empty string
InitializationString None
InsensitiveResultSetBufferSize 2048 (KB of memory)
JavaDoubleToString false
JDBCBehavior 1
LoadBalancing false
LoginTimeout 0 (no timeout)
MaxPooledStatements 0 (driver’s internal prepared statement pooling is not enabled)
MaxStatements 0 (driver’s internal prepared statement pooling is not enabled)
Password None
PortNumber Varies depending on operating system
QueryTimeout 0 (query does not time out)
RegisterStatementPoolMonitorMBean false
ServerName None
SpyAttributes None
TrustStore None
TrustStorePassword None
User None
ValidateServerCertificate true