FailoverGranularity
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Purpose
Determines
how the driver behaves if exceptions occur while trying to reestablish
a lost connection. This property is ignored if FailoverMode=connect.
Valid Values
nonAtomic | atomic | atomicWithRepositioningBehavior
If
set to nonAtomic, the driver continues with the failover
process and posts any exceptions on the statement on which they occur.
If
set to atomic, the driver fails the entire failover process
if an exception is generated as the result of restoring the state
of the connection. The driver stops trying to connect to an alternative
server and returns an exception indicating that the connection was
lost. If an exception is generated as a result of restoring the
state of work in progress by re-executing the Select statement,
the driver continues with the failover process, but generates an
exception warning that the Select statement must be reissued.
If
set to atomicWithRepositioning, the driver fails
the entire failover process if any exception is generated as the
result of restoring the state of the connection or the state of
work in progress. The driver stops trying to connect to an alternative
server and returns an exception indicating that the connection was
lost.
Default
nonAtomic
Data Type
String