SP ODBC RetryOnError

Cantor, Scott cantor.2 at osu.edu
Mon Dec 12 13:24:47 UTC 2022


> I recognize that it is doing two separate checks, and returning two
> boolean values. But unless I am really off of my rocker there are two
> loops in the code:

Yes, but the inner loop doing the retry check is bypassed as soon as a retryable code is found, so the first retryable error sets the return flag, and it doesn't matter which code happened to have been the one to trigger it.

> However, if the outer loop executes multiple times, and the last error
> code returned by it is not in the retry list, the final value of
> res.first returned is false, even if it was set to true by the check in
> one of the earlier iterations of the loop.

Nothing in the outer loop resets the flag to false.

-- Scott




More information about the users mailing list