Re: Transient errors
Posted by: Filipe Silva
Date: June 30, 2021 04:00AM

No, there isn't a list of error codes you could consider retriable, at least that I know of.

Theoretically you could check if the exceptions thrown are subclasses of java.sql.SQLTransientException but that won't work either because Connector/J is not a very good Exception classification in this regard.

So, my advice would be for you to check the error codes you are getting and classify them as you go. You can check the entire list of error codes and select the best candidates yourself (maybe someone else already did this?) and keep fine tuning your error handling code.

Options: ReplyQuote

Written By
June 27, 2021 01:16PM
June 27, 2021 01:27PM
June 27, 2021 02:24PM
June 29, 2021 07:47AM
June 29, 2021 10:21AM
Re: Transient errors
June 30, 2021 04:00AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.