skip to main content
DataDirect Connect Drivers : Oracle Driver : Failover Properties
  
Failover Properties
The following table summarizes the connection properties that control how failover works with the Oracle driver. See Connection Properties for details about configuring each property.
Table 51. Summary: Failover Properties for the Oracle Driver
Property
Characteristic
AlternateServers
One or multiple alternate database servers. An IP address or server name identifying each server is required. Port number and the ServiceName or SID connection properties are optional. If the port number is unspecified, the port specified for the primary server is used. If a port number is not specified for the primary server, the default port number of 1521 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.
FailoverGranularity
Determines whether the driver fails the entire failover process or continues with the process if exceptions occur while trying to reestablish a lost connection. The default is nonAtomic (the driver continues with the failover process and posts any exceptions on the statement on which they occur).
FailoverMode
The failover method you want the driver to use. The default is connect (connection failover is used).
FailoverPreconnect
Specifies whether the driver tries to connect to the primary and an alternate server at the same time. The default is false (the driver tries to connect to an alternate server only when failover is caused by an unsuccessful connection attempt or a lost connection).
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 data source connections. The default is 1521.
ServerName
IP address or server name of primary database server. This property is supported only for data source connections.
ServiceName
Database service name that specifies the database used for the connection. This property is mutually exclusive with the SID property.
SID
Oracle System Identifier that refers to the instance of the Oracle database running on the server. This property is mutually exclusive with the ServiceName property. The driver does not set a default.
See Using Failover and Using Client Load Balancing for overviews of failover and client load balancing.