Re: JDBC error codes to detect duplicates?

From: Max Khon <fjoe(at)iclub(dot)nsu(dot)ru>
To: David Wall <d(dot)wall(at)computer(dot)org>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: JDBC error codes to detect duplicates?
Date: 2001-03-01 18:41:56
Message-ID: Pine.BSF.4.21.0103020041110.98084-100000@iclub.nsu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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)

/fjoe

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message David Wall 2001-03-01 19:06:47 Re: JDBC error codes to detect duplicates?
Previous Message David Wall 2001-03-01 18:20:28 JDBC error codes to detect duplicates?