Postgres Pro
Downloads
Home   >   mailing lists

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

From Wieger Uffink
Subject Error Codes, JDBC, SQLExceptions
Date
Msg-id 3B8665C5.A8A25641@usmedia.nl
Whole thread Raw
In response to help on delete trigger.  ("Sundararajan" <sdn@srasys.co.in>)
Responses Re: Error Codes, JDBC, SQLExceptions  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
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
--
Wieger Uffink
tel: +31 20 428 6868
fax: +31 20 470 6905
web: http://www.usmedia.nl

pgsql-general by date:

Previous
From: Stephan Bergmann
Date:
Subject: libpq
Next
From: "Jeff Eckermann"
Date:
Subject: Re: problems transfering databases