Re: SQLState with pg74.1jdbc3.jar - Mailing list pgsql-jdbc

From Paul Thomas
Subject Re: SQLState with pg74.1jdbc3.jar
Date
Msg-id 20040115151140.A25805@bacon
Whole thread Raw
In response to SQLState with pg74.1jdbc3.jar  (Moreno Mauri <moreno.mauri@italtel.it>)
List pgsql-jdbc
On 15/01/2004 14:50 Moreno Mauri wrote:
> Hi all,
> I'm a newbie in JDBC code.
>
> I tried to execute a Statement.executeUpdate() method to insert a row
> already present in my Postgresql DB.
>
> With JDBC I receive a SQLException but I would like to have
> more informations about the error (something like Duplicate Key
> Exception).
>
> I read that SQLException class have the getSQLState() method, but
> when I call it, the result is null (the getErrorCode() return always 0).

What version of PostgreSQL are you running? To get the error codes
requires a 7.4 server.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

pgsql-jdbc by date:

Previous
From: Moreno Mauri
Date:
Subject: SQLState with pg74.1jdbc3.jar
Next
From: "Dennis Romero L."
Date:
Subject: Re: SQLState with pg74.1jdbc3.jar