skip to main content
Using the JDBC Client : JDBC Connection Properties : ConnectionRetryCount
 

ConnectionRetryCount

Description

The number of times the JDBC Client retries connection attempts to the primary OpenAccess SDK Server, and if specified, alternate OpenAccess SDK Servers until a successful connection is established. Valid values are 0 and any positive integer.
If an application sets a login timeout value (for example, using DataSource.loginTimeout or DriverManager.loginTimeout), the login timeout takes precedence over this property. For example, if the login timeout expires, any connection attempts stop.
The ConnectionRetryDelay property sets the wait interval, in seconds, between retry attempts.

Valid Values

0 | x
where x is a positive integer.
When 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 and alternate servers are specified using the AlternateServers property, the driver retries the list of servers (primary and alternate) twice after the initial retry attempt.

Default

0

Data type

int