Re: SQLException and error code - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: SQLException and error code
Date
Msg-id 42E6C843.70307@opencloud.com
Whole thread Raw
In response to Re: SQLException and error code  (Peter.Zoche@materna.de)
List pgsql-jdbc
Peter.Zoche@materna.de wrote:
> 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!

Those codes are actually SQLSTATEs.

> So why is there a method getErrorCode(),

It's defined by the JDBC spec, we don't have any choice about whether it
is there or not.

> if the only thing it does
> is to return zero?

Back to my original question: what are you expecting it to return? It
can't return a SQLSTATE because it returns an int and SQLSTATE is
alphanumeric. We don't have any other useful error code. So we just
return 0 because we have to return *something*.

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Timestamp Summary
Next
From: Oliver Jowett
Date:
Subject: Re: Configuring Connections