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 that is performed by the last Select statement that was 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.

Data Source Methods

public String getFailoverMode()

public void setFailoverMode(String)

Default

connect

Data Type

String

See also

Failover