Specifying Connection Retry

Connection retry allows the JDBC Client to retry connections to the primary database server, and if specified, alternate servers until a successful connection is established. You use the ConnectionRetryCount and ConnectionRetryDelay properties to enable and control how connection retry works. For example:

jdbc:openaccess://server1:19986; serverDataSource=SDSN1;User=test; Password=secret;
AlternateServers=(server2:19986; serverDataSource=SDSN2, server3:19986; serverDataSource=SDSN3);
ConnectionRetryCount=2;ConnectionRetryDelay=5

In this example, if a successful connection is not established on the JDBC Client’s first pass through the list of database servers (primary and alternate), the JDBC Client retries the list of servers in the same sequence twice (ConnectionRetryCount=2). Because the connection retry delay has been set to five seconds (ConnectionRetryDelay=5), the JDBC Client waits five seconds between retry passes.