Re: Error Codes, JDBC, SQLExceptions - Mailing list pgsql-general

From Barry Lind
Subject Re: Error Codes, JDBC, SQLExceptions
Date
Msg-id 3B868F33.8020908@xythos.com
Whole thread Raw
In response to help on delete trigger.  ("Sundararajan" <sdn@srasys.co.in>)
List pgsql-general
Wieger,

The server does not have a concept of error codes currently (it is on
the TODO list).  Therefore the JDBC driver has no error code to report
since it doesn't get one from the backend. When the server supports
error codes the JDBC driver will as well.

thanks,
--Barry



Wieger Uffink wrote:
> Hi,
>
> Im accessesing a postgreSQL db through JDBC, and I would like take make
> use of the method, getErrorCode in the SQLException class as in
> java.sql.
>
> So far I have been able to retreive exception messages but not the error
> codes in case of an SQL exception.
>
> I would like to know if postgreSQL propegates any errorcodes at all,
> since I found some post earlier on this list saying it was not
> implemented, but that post didnt refer to any specific version. If it is
> could someone also point out to me where these codes are defined?
>
> I could ofcourse base my excepion handling on the messages but I'd
> rather use codes.
>
> thanks in advance,
> Wieger
>



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Error Codes, JDBC, SQLExceptions
Next
From: Wieger Uffink
Date:
Subject: Re: Error Codes, JDBC, SQLExceptions