Failover properties
- Last Updated: May 8, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- Documentation
The following table summarizes the connection properties that control how failover works with the Greenplum driver. See Connection property descriptions for details about configuring each property.
| Property | Characteristic |
|---|---|
| AlternateServers | One or multiple alternate database servers.
An IP address or server name identifying each server is required.
Port number and the connection property DatabaseName are optional.
If the port number is unspecified, the port number specified for
the primary server is used. If a port number is unspecified for
the primary server, the default port number of 5432 is
used. |
| ConnectionRetryCount | Number of times the driver retries the primary
database server, and if specified, alternate servers until a successful
connection is established. The default is 5. |
| ConnectionRetryDelay | Wait interval, in seconds, between connection
retry attempts when the ConnectionRetryCount property is set to
a positive integer. The default is 1. |
| DatabaseName | Name of the database to which you want to connect. |
| LoadBalancing | Sets whether the driver will use client load
balancing in its attempts to connect to the database servers (primary
and alternate). If client load balancing is enabled, the driver
uses a random pattern instead of a sequential pattern in its attempts
to connect. The default is false (client load balancing
is disabled). |
| PortNumber | Port listening for connections on the primary
database server. This property is supported only for DataSource
connections. The default port number is 5432. |
| ServerName | IP address or server name for the primary database server. This property is supported only for DataSource connections. |