The Connection Retry Settings section of the Outbound SQL Server XA Environment contains the top-level parameters displayed in the following table.
Table 46 Outbound SQL Server XA Adapter Environment Connection Retry Settings
Name |
Description |
Required Value |
---|---|---|
ConnectionRetries |
Specifies the number of retries to establish a connection with the SQL Server database upon a failure to acquire one. |
an integer indicating the number of attempts allowed to establish a connection. The configured default is 0. |
Specifies the milliseconds of pause before each reattempt to access the database. This setting is used in conjunction with the ’Connection Retries’ setting. For example: In the event that the Adapter cannot connect to the Database, the Adapter will try to reconnect to the database in 5 second intervals, a total of 10 times, when the Connection Retries property is set at 10 and the Connection Retry Interval property is 5000. |
A valid numeric value. The default is 1000. |