Re: SQLException.getErrorCode ?

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