skip to main content
Configuring the JDBC Client : Configuring Connection Failover for the JDBC Client : Specifying Primary and Alternate Servers
 

Specifying Primary and Alternate Servers

Connection information for primary and alternate servers can be specified using either a connection URL through the JDBC Driver Manager or a JDBC data source. For example, the following connection URL for the JDBC Client specifies connection information for the primary and alternate servers using a connection URL:

jdbc:openaccess://server1:19986;serverDataSource=SDSN1;User=test;
Password=secret;AlternateServers=(server2:19986;serverDataSource=SDSN2,server3:19986;serverDataSource=SDSN3)
In this example:

...server1:19986;serverDataSource=SDSN1...
is the part of the connection URL that specifies connection information for the primary server. Alternate servers are specified using the AlternateServers property. For example:

...;AlternateServers=(server2:19986;serverDataSource=SDSN2,
server3:19986;serverDataSource=SDSN3)
Similarly, the same connection information for the primary and alternate servers specified using a JDBC data source would look like this:

OpenAccessDataSource mds = new OpenAccessDataSource();
mds.setDescription("My OpenAccessDataSource");
mds.setServerName("server1");
mds.setPortNumber(19986);
mds.setServerDataSource("SDSN1");
mds.setUser("test");
mds.setPassword("secret");
mds.setAlternateServers(server2:19986;serverDataSource=SDSN2, server3:19986;ServerDataSource=SDSN3)
In this example, connection information for the primary server is specified using the ServerName, PortNumber, and serverDataSource properties. Connection information for the alternate servers is specified using the AlternateServers property.