Re: Huh? ErrorCode/SQLstate are null?

From: Dror Matalon <dror(at)zapatec(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Huh? ErrorCode/SQLstate are null?
Date: 2002-10-02 17:32:47
Message-ID: 20021002173247.GS2147@four.zapatec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

Follow up to this question, not really JDBC specific. Is there a
specific centralized location for the error messages, or are these just
inline in different parts of the postmaster code?
Also, how likely is it that the error string would change between
versions?

In other words, if I want to check for
Relation "adb_email" does not exist
So that I can conver it to
There is no "adb_email" table in the database

Would I be running the chance that in the next version the error message
is going to change?
Is this a bad idea?

On Wed, Oct 02, 2002 at 09:27:31AM -0700, Barry Lind wrote:
> Please see the many past posts in the archives on this topic. But the
> short answer is: the postgres server doesn't yet support error codes and
> therefore neither does the jdbc driver. It is on the todo list for both
> however, but no one has yet stepped up to implement it.
>
> --Barry
>
> beh(at)icemark(dot)net wrote:
> > Hi there,
> >
> > how can I actually find out more about an SQL error except by
> > looking at the message in an exception?
> >
> > If I try to insert into a non-existing relation or an insert
> > generates a duplicate key, the thrown SQLException yields SQLstate
> > null and ErrorCode 0... Just the result from
> > SQLException.getMessage() seems to make sense...
> >
> >
> > I am using postresql-7.2.1-2 from Debian "testing" on linux-i386.
> > The error occurs on both the current libpgjava package as well as
> > the latest beta driver (pg73b1jdbc3.jar) from jdbc.postgresql.org.
> >
> >
> > Is that behaviour 'normal' in the postgresql JDBC driver?
> > Or is there some problem with the setup on my side?
> >
> >
> > Benedikt
> >
> > BEAUTY, n. The power by which a woman charms a lover and terrifies a
> > husband.
> > (Ambrose Bierce, The Devil's Dictionary)
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Dror Matalon
Zapatec Inc
1700 MLK Way
Berkeley, CA 94709
http://www.zapatec.com

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mike Abraham 2002-10-02 23:10:54 ResultSet Column Name Problem in pgjdbc2.jar?
Previous Message Barry Lind 2002-10-02 16:27:31 Re: Huh? ErrorCode/SQLstate are null?