Specifies the type of failover method the driver uses.
If using a tnsnames.ora file to retrieve connection information, do not specify this property. See "Using tnsnames.ora files" for more information.
Valid values
connect | extended | select
Behavior
If set to connect, the driver provides failover protection for new connections only.
If set to extended, the driver provides failover protection for new and lost connections, but not any work in progress.
If set to select, the driver provides failover protection for new and lost connections. In addition, it preserves the state of work that is performed by the last Select statement that is executed on the Statement object.
Notes
The AlternateServers property specifies one or multiple alternate servers for failover and is required for all failover methods. To turn off failover, do not specify a value for the AlternateServers property.
The FailoverGranularity property determines which action the driver takes if exceptions occur during the failover process.
The FailoverPreconnect property specifies whether the driver tries to connect to multiple database servers (primary and alternate) at the same time.
The AlternateServers property specifies one or multiple alternate servers for failover and is required for all failover methods. To turn off failover, do not specify a value for the AlternateServers property.