Specifies the number of times the driver retries connection attempts to the primary database server, and if specified, alternate servers before returning a connection failure.
Valid Values
0 | x
where:
x
is a positive integer that represents the number of retries.
Behavior
If set to 0, the driver does not try to reconnect after the initial unsuccessful attempt.
If set to x, the driver retries connection attempts the specified number of times. If a connection is not established during the retry attempts, the driver returns an exception that is generated by the last database server to which it tried to connect.
Example
If this property is set to 2, the driver retries the single leader node (as specified by ServerName and PortNumber) twice after the initial retry attempt.
Notes
If an application sets a login timeout value (for example, using DataSource.loginTimeout or DriverManager.loginTimeout), and the login timeout expires, the driver ceases connection attempts.
The ConnectionRetryDelay property specifies the wait interval, in seconds, to occur between retry attempts.
If an application sets a login timeout value (for example, using DataSource.loginTimeout or DriverManager.loginTimeout), and the login timeout expires, the driver ceases connection attempts.