High Availability for SQLFire Procedures

If an error occurs before a procedure has returned any rows to the client, then SQLFire automatically re-executes the procedure.

Procedure and result processor implementations can use the isPossibleDuplicate() method to determine if SQLFire re-executed a procedure after a SQLFire member failed. This type of detection is necesary for certain implementations that perform write operations that can lead to duplicate entries on procedure re-execution.

If an error occurs after rows have been returned to the client, then SQLFire throws an exception and does not attempt to retry the procedure.