skip to main content
Configuring the JDBC Client : Configuring Connection Failover for the JDBC Client : Connection Failover Properties
 

Connection Failover Properties

The following table summarizes the connection properties that control how connection failover works with the JDBC Client. Refer to the OpenAccess SDK Client Reference for details about configuring each property.
Table 24. Summary: Connection Failover Properties for the JDBC Client
Property
Characteristic
AlternateServers
List of alternate database servers. An IP address or server name and a port number are required for each server. The serverDataSource connection property is optional.
ConnectionRetryCount
Number of times the JDBC Client retries the primary database server, and if specified, alternate servers until a successful connection is established. The initial default is 0.
ConnectionRetryDelay
Wait interval, in seconds, between connection retry attempts when the ConnectionRetryCount property is set to a positive integer. The initial default is 3.
LoadBalancing
Sets whether the JDBC Client will use client load balancing in its attempts to connect to the list of database servers (primary and alternate). If client load balancing is enabled, the JDBC Client uses a random pattern instead of a sequential pattern in its attempts to connect. The initial default is false (client load balancing is not used).
Refer to the OpenAccess SDK Client Reference for overviews of connection failover and client load balancing.