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.20010301212711.00a4c030@mail.retep.org.uk
Whole thread Raw
In response to Re: JDBC error codes to detect duplicates?  ("David Wall" <d.wall@computer.org>)
List pgsql-interfaces
At 11:06 01/03/01 -0800, David Wall wrote:
> > 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)
>
>Too bad.  Is the definitive list of error messages documented? (Probably
>yes, but where?)  Perhaps we could write an ugly implementation that would
>parse the error message and return meaningful errors codes so that all users
>don't suffer the same problem.

problem is two fold:

1: Enlarges the driver, which affects those who use the driver over a 
network connection (some people still use JDBC direct in applets)

2: It becomes sensitive to changes during development.

An example of  #2 is where the Timestamp format changed just slightly, then 
getTimestamp broke.

Peter



pgsql-interfaces by date:

Previous
From: Peter Mount
Date:
Subject: Re: JDBC error codes to detect duplicates?
Next
From: "David Wall"
Date:
Subject: Re: JDBC error codes to detect duplicates?