Re: SQLException and error code

Because in the postgresql documentation you can find the following page:

http://www.postgresql.org/docs/8.0/interactive/errcodes-appendix.html#ERRCOD
ES-TABLE

There you can see all ERROR CODES!

So why is there a method getErrorCode(), if the only thing it does
is to return zero?

-----Ursprüngliche Nachricht-----
Von: Oliver Jowett [mailto:oliver(at)opencloud(dot)com]
Gesendet: Dienstag, 26. Juli 2005 16:04
An: Peter(dot)Zoche(at)materna(dot)de
Cc: pgsql-jdbc(at)postgresql(dot)org
Betreff: Re: [JDBC] SQLException and error code

Peter(dot)Zoche(at)materna(dot)de wrote:

> I am using postgresql-8.0-310.jdbc3.jar in my application.
> In order to get the error code from an SQLException I have
> to use sqlexception.getSQLState(). Shouldn't it be
> getErrorCode()?

We get a SQLSTATE from the server already, so it makes sense to make
that available via getSQLState().

What exactly do you suggest we return from getErrorCode()?

-O