pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Mount <peter@retep.org.uk>
To: David Wall <d.wall@computer.org>
To: pgsql-interfaces@postgresql.org
Subject: Re: JDBC error codes to detect duplicates?
Date: Thu, 01 Mar 2001 21:28:36 +0000
Message-ID: <5.0.2.1.0.20010301212711.00a4c030@mail.retep.org.uk> (raw)
In-Reply-To: <02df01c0a282$c352b700$5a2b7ad8@expertrade.com>
References: <Pine.BSF.4.21.0103020041110.98084-100000@iclub.nsu.ru>

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




view thread (12+ messages)  latest in thread

Message-ID: <5.0.2.1.0.20010301212711.00a4c030@mail.retep.org.uk>
Permalink:  ../5.0.2.1.0.20010301212711.00a4c030@mail.retep.org.uk/
Also on:    postgresql.org/message-id/5.0.2.1.0.20010301212711.00a4c030@mail.retep.org.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: peter@retep.org.uk, d.wall@computer.org
  Subject: Re: JDBC error codes to detect duplicates?
  In-Reply-To: <5.0.2.1.0.20010301212711.00a4c030@mail.retep.org.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox