Обсуждение: Error codes in SQLException

Hi list,

I was just wondering if there is a overview somewhere with the integer
values returned by SQLException when calling getErrorCode().

Thanks!



Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230

Στις Τρίτη 30 Οκτώβριος 2007 12:06, ο/η Christian Rengstl έγραψε:
> Hi list,
>
> I was just wondering if there is a overview somewhere with the integer
> values returned by SQLException when calling getErrorCode().

Browsing at the sources of 7.4.12 (dont shout please!! i know we must upgrade
in the future), i dont see any reference to getErrorCode() in PSQLException.

The right way however is to use the standardized getSQLState() according to
http://www.postgresql.org/docs/7.4/interactive/errcodes-appendix.html


> Thanks!
>
>
>
> Christian Rengstl M.A.
> Klinik und Poliklinik für Innere Medizin II
> Kardiologie - Forschung
> Universitätsklinikum Regensburg
> B3 1.388
> Franz-Josef-Strauss-Allee 11
> 93053 Regensburg
> Tel.: +49-941-944-7230
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
Achilleas Mantzios

Christian Rengstl wrote:
> I was just wondering if there is a overview somewhere with the integer
> values returned by SQLException when calling getErrorCode().

getErrorCode() will return a vendor specific code; this is the
third argument in the three-argument constructor of
java.sql.SQLException.

As far as I can see this constructor is never used in PostgreSQL,
so I would say that getErrorCode() will always return 0.

This makes sense since PostgreSQL uses no vendor specific
error codes, but the (supposedly fairly standardized)
SQLSTATEs (see
http://www.postgresql.org/docs/current/static/errcodes-appendix.html).

You can get those with getSQLState().

Yours,
Laurenz Albe