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

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@informactis.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).-''  (((!.'  ((!.-'            /
 ---------------------------------------------------------------------------------------------
 

Attachment
Steve SAUTETNER writes:

> Where can I find the list of error codes and description of the
> postgresql.Driver.SQLException ?

PostgreSQL doesn't provide any error codes yet.  Sorry.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


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@informactis.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@postgresql.org)
>
>
> Part 1.3
>
> Content-Type:
>
> text/plain
> Content-Encoding:
>
> binary
>
>