Ryan Daniels wrote:
> When I get a PSQLException, how do I identify which type it is? I need
> to be able to distinguish which error occurred.
Have a look at the JDBC documentation, in particular the documentation
Note the getErrorCode() and getSQLState() members?
The error code is usually quite sufficient for program flow control and
error handling decisions. See the PostgreSQL error code documentation:
Note that you can match error codes by class (the first byte) as well as
by exact error code. As a result, you can easily do things like "Retry
the transaction on all possibly tansient errors" in quite a generic way.
The documentation for PSQLException shows you how to get information
from it, too:
it provdes getServerErrorMessage(), which returns about as much as you'd
ever want to know:
In response to
pgsql-jdbc by date
|Next:||From: mark_addleman||Date: 2008-10-15 23:14:07|
|Subject: Re: COPY support in JDBC driver?|
|Previous:||From: Ryan Daniels||Date: 2008-10-15 05:01:12|
|Subject: PSQLException - How to Identify Type?|