skip to main content
Connection property descriptions : LoadBalancing
  

Try DataDirect Drivers Now

LoadBalancing

Purpose

Determines whether the driver uses client load balancing in its attempts to connect to the database servers (primary and alternate). You can specify one or multiple alternate servers by setting the AlternateServers property.
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

true | false

Behavior

If set to true, the driver uses client load balancing and attempts to connect to the database servers (primary and alternate) in random order. The driver randomly selects from the list of primary and alternate servers which server to connect to first. If that connection fails, the driver again randomly selects from this list of servers until all servers in the list have been tried or a connection is successfully established.
If set to false, the driver does not use client load balancing and connects to each server based on their sequential order (primary server first, then, alternate servers in the order they are specified).

Data source method

setLoadBalancing

Default

false

Data type

boolean

See also

Using tnsnames.ora files
Configuring failover