Thin JDBC client - how to interpret SQLExceptions
From: Richard Price <richard_at_ascend.nu>
Date: Wed, 14 Jul 1999 08:40:09 -0600
Message-ID: <fi1j3.225$Nc2.16481_at_news.uswest.net>
Hi - I'm trying to get a handle on deciphering the SQLState values that are available in the SQLException objects that can be caught during a session. I'd like to think that I can interpret these and act accordingly. E.g. for some data errors I want to keep processing. For others, like connections reset or dropped I want to backout as gracefully as possible.
Date: Wed, 14 Jul 1999 08:40:09 -0600
Message-ID: <fi1j3.225$Nc2.16481_at_news.uswest.net>
Hi - I'm trying to get a handle on deciphering the SQLState values that are available in the SQLException objects that can be caught during a session. I'd like to think that I can interpret these and act accordingly. E.g. for some data errors I want to keep processing. For others, like connections reset or dropped I want to backout as gracefully as possible.
I have an SQL book that states the ANSI SQLState conventions is not supported universally and therefore is deprecated essentially. If this is the case, where can I get a definitive list of Oracle's codes as that may come back via the Thin JDBC client?
If anyone knows of a good resource/overview of exception handling with JDBC, I'd love to read it.
Thanks!
Richard Received on Wed Jul 14 1999 - 16:40:09 CEST