Specifies the number of times the driver retries connection attempts to the server until a successful connection is established.
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 server to which it tried to connect.
Example
If this property is set to 2, the driver retries the server 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.