Re: JDBC error codes to detect duplicates?

Поиск
Список
Период
Сортировка
От Peter Mount
Тема Re: JDBC error codes to detect duplicates?
Дата
Msg-id 5.0.2.1.0.20010301210608.0222ab40@mail.retep.org.uk
обсуждение исходный текст
Ответ на Re: JDBC error codes to detect duplicates?  (Max Khon <fjoe@iclub.nsu.ru>)
Ответы Re: JDBC error codes to detect duplicates?
Список 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 по дате отправления:

Предыдущее
От: Peter Mount
Дата:
Сообщение: Re: Alternative to setBinaryStream
Следующее
От: Peter Mount
Дата:
Сообщение: Re: JDBC error codes to detect duplicates?