Re: SQLException.getErrorCode ? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: SQLException.getErrorCode ?
Date
Msg-id alpine.BSO.2.00.1005011540250.28968@leary.csoft.net
Whole thread Raw
In response to Re: SQLException.getErrorCode ?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: SQLException.getErrorCode ?  (Maxime Lévesque <maxime.levesque@gmail.com>)
List pgsql-jdbc

On Sat, 1 May 2010, Kevin Grittner wrote:

> Kris Jurka <books@ejurka.com> wrote:
>
>> As I said earlier you need to check SQLException.getSQLState, not
>> getErrorCode.
>
> Why anyone would want to use error code instead of SQLSTATE is
> beyond me, but since they're out there, perhaps we should implement
> getErrorCode to interpret SQLSTATE as a base 36 number, and return
> that number?  It might take less time than fielding the next
> complaint.  ;-)
>
> The biggest down side is that we'd have to document it....
>

Exactly, who's going to maintain this list of alternate error code
versions?  If the main project was to put this version of the error codes
in the master table of error codes, then I guess it would be OK.  I can't
imagine proposing that though, unless there are other driver projects that
are in the same position.

Kris Jurka

pgsql-jdbc by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: SQLException.getErrorCode ?
Next
From: Maxime Lévesque
Date:
Subject: Re: SQLException.getErrorCode ?