Re: : SQLException.getErrorCode() : Where can I find list of error code and description ?

From: Barry Lind <barry(at)xythos(dot)com>
To: Steve SAUTETNER <ssa(at)informactis(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: : SQLException.getErrorCode() : Where can I find list of error code and description ?
Date: 2001-07-11 18:36:54
Message-ID: 3B4C9CC6.3010300@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Steve,

Postgres doesn't yet have a notion of error code at the server level.
Therefore the JDBC driver also doesn't have a notion of error codes.

As far are the exceptions themselves go, all errors on the backend are
fatal in the sense that they abort the current transaction and require a
rollback. So in general there aren't any backend errors that would be
considered a warning in postgres.

thanks,
--Barry

Steve SAUTETNER wrote:

> Hi everybody,
>
> i use the postgresql jdbc driver and i need to get error code's of the
> thrown SQLException's in order to treat these as fatal errors or simple
> warnings.
>
> Where can I find the list of error codes and description of the
> postgresql.Driver.SQLException ?
>
> ---------------------------------------------------------------------------------------------
>
> / Steve SAUTETNER ssa(at)informactis(dot)com
> ("`-''-/").___..--''"`-._ \
> | INFORMACTIS Tél: 04 72 69 52 00 @..@ `6_ 6 )
> `-. ( ).`-.__.`) |
> | DEPT R&D Fax: 04 72 69 52 09 (\--/) (_Y_.)'
> ._ ) `._ `. ``-..-' |
> | 115 Bd Stalingrad (.>__<.) `--'_..-_/
> /--'_.' ,' |
> \ 69 100 VILLEURBANNE ^^^ ^^^ (ll).-''
> (((!.' ((!.-' /
> ---------------------------------------------------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
> Part 1.3
>
> Content-Type:
>
> text/plain
> Content-Encoding:
>
> binary
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2001-07-11 18:38:26 RE: [PATCH] setTimestamp(int, Timestamp) fails on null timestamp
Previous Message Tom Lane 2001-07-11 18:27:41 Re: can't write a BLOB, 7.1.2