Support for multiple JDBC Servers and/or Data servers is available on the CDD server name fields and the JDBC connection string.

 

<servername>[:<port>][!<servername>[:<port>]][!<servername>[:<port>]]...[!DISTRIBUTE]

 

Note:  Each instance of <servername>[:<port>] is spearated by an exclaimation (!) mark.

 

For example - if you have two JDBC servers set up for redundancy - one on a server called PRIMARY, listening on port 7323

and another server called SECONDARY, listening on port 8754, the gateway server name would be:

 

Example:

PRIMARY:7323!SECONDARY:8754

 

When a list of servers is provided - CONNX will start with the first server listed.  If the connection fails for that server, it will then serially loop through

all the servers from that point forward, wrapping back around to the beginning if necessary, until all options are exhausted, or a successful connection is established..

 

The DISTRIBUTE option may be added to the list of JDBC Servers and/or Data Servers. By using this option, CONNX will randomly choose a server from the list initially.

If the connection fails for that server, it will then serially loop through all the servers from that point forward, wrapping back around to the beginning if necessary, until all options
are exhausted, or a successful connection is established.  This is used for load balancing purposes.

 

Example:

PRIMARY:7323!SECONDARY:8754!DISTRIBUTE

 

Note: The DISTRIBUTE keyword must be in all upper case letters.