skip to main content
Configuring the JDBC Client : Configuring Connection Failover for the JDBC Client : Using the AlternateServers Property
 

Using the AlternateServers Property

Connection information for alternate servers is specified using the AlternateServers property with either a connection URL or a JDBC data source. The value of the AlternateServers property is a string that has the format:

(servername1:port1;serverDataSource=SDSN1;
servername2:port2;serverDataSource=SDSN2...)
where:
servername1 is the IP address or server name of the first alternate database server, servername2 is the IP address or server name of the second alternate database server, and so on. The IP address or server name is required for each alternate server entry.
port1 is the port number on which the first alternate database server is listening, port2 is the port number on which the second alternate database server is listening, and so on. The port number is required for each alternate server entry.
serverDataSource=SDSN2 is the server data source name for the first alternate server, serverDataSource=SDSN3 is the server data source name for the second alternate server, and so on. Currently, the only optional property that can be set for the alternate server is serverDataSource. For example:

jdbc:openaccess://server1:19986;serverDataSource=SDSN1;User=test;Password=secret;
AlternateServers=(server2:19986;serverDataSource=SDSN2)