Huh? ErrorCode/SQLstate are null?

From: beh(at)icemark(dot)net
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Huh? ErrorCode/SQLstate are null?
Date: 2002-10-02 13:23:02
Message-ID: Pine.LNX.4.44.0210021511430.6202-100000@berenium.icemark.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


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)

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message mike beachy 2002-10-02 16:02:36 build.xml patch
Previous Message Nic Ferrier 2002-10-02 11:50:42 installation failure using ANT with 7.3 CVS