Re: No error code on unique constraint violation

From: Ian Pilcher <i(dot)pilcher(at)comcast(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: No error code on unique constraint violation
Date: 2004-11-29 15:22:01
Message-ID: cofeqp$ptd$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Laurent Duperval wrote:
> Hello,
>
> I'm using postgres-jdbc-80b1.308 (type 3) with Postgres 8 beta 5. I'm
> running some unit tests where I test unique constraint violations. When
> I get an exception, I check the error code to see what it is and take
> appropriate action. With SQL Server and Firebird I get a specific error
> code but with the Postgres driver I get 0. I'm not sure if this is a
> driver or a Postgres problem.
>

You need to check the SQLSTATE string -- SQLException.getSQLState().

--
========================================================================
Ian Pilcher i(dot)pilcher(at)comcast(dot)net
========================================================================

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Laurent Duperval 2004-11-29 16:05:02 Re: No error code on unique constraint violation
Previous Message Laurent Duperval 2004-11-29 14:57:57 No error code on unique constraint violation