Krishnakanth Rao wrote:
> Hi,
>
> I'am using the jdbc driver pg73jdbc3.jar in my jdbc code to acces PostGRE
> SQL. Whenever a sql exception occurs it doesnt give me the appropriate error
> code , eg referential integrity constraint voilated etc. The error code from
> the SQLException is always zero.
>
> How do I obtain the exact error code as mentioned in PostGRE documents
Use a 7.4 or later driver (get a recent driver from jdbc.postgresql.org)
against a 7.4 or later server; you should then get a useful SQLState in
most cases.
-O