Purpose

Specifies the type of failover method the driver uses.

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 performed by the last Select statement 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.
  • When MultiSubnetFailover is enabled, the driver does not support FailoverMode=select. If MultiSubnetFailover=true and FailoverMode=select, the driver downgrades the FailoverMode to extended and provides the following warning.
    failoverMode=select is not supported for AlwaysOn Availability Group,
downgraded to failoverMode=extended

Data source method

public String getFailoverMode()

public void setFailoverMode(String)

Default

connect

Data type

String

See also

  • Note: For more information on connection failover and different levels of failover protection provided by the driver, refer to Failover in the Progress DataDirect for JDBC Drivers Reference.
  • Connection property descriptions