Re: JDBC error codes to detect duplicates? - Mailing list pgsql-interfaces

From Peter Mount
Subject Re: JDBC error codes to detect duplicates?
Date
Msg-id 5.0.2.1.0.20010301210608.0222ab40@mail.retep.org.uk
Whole thread Raw
In response to Re: JDBC error codes to detect duplicates?  (Max Khon <fjoe@iclub.nsu.ru>)
Responses Re: JDBC error codes to detect duplicates?
List pgsql-interfaces
At 00:41 02/03/01 +0600, Max Khon wrote:
>hi, there!
>
>On Thu, 1 Mar 2001, David Wall wrote:
>
> > It seems that when an INSERT causes a duplicate key exception for
> > unique/primary keys, the JDBC library is throwing the SQL exception but
> > there is no code that lets my program detect a duplicate key error, or 
> which
> > key caused the duplicate error.
> >
> > Is there a plan for the JDBC to return the codes for postgres back to the
> > program?  I running 7.1beta4 now.
>
>AFAIK clean implementation of such feature is not possible because backend
>protocol does not have error codes (only error messages)

Thats correct. It's also not practical to get the driver to translate 
because the format of the messages can change between releases as well.

Peter


>/fjoe



pgsql-interfaces by date:

Previous
From: Peter Mount
Date:
Subject: Re: Alternative to setBinaryStream
Next
From: Peter Mount
Date:
Subject: Re: JDBC error codes to detect duplicates?