Postgres Pro
Downloads
Home   >   mailing lists

Re: Where's SQL error code??? - Mailing list pgsql-jdbc

From Ken McArthur
Subject Re: Where's SQL error code???
Date
Msg-id 200305312120.14834.kwmcarthur@attbi.com
Whole thread Raw
Responses Re: Where's SQL error code???
List pgsql-jdbc
Tree view 
On Saturday 31 May 2003 04:57 pm, Ken McArthur wrote:
Switching to postgres from mysql.  mysql jdbc driver
returns the sql error code to SQLWarning.getErrorCode()
(i.e. insert with duplicate entry throws adn SQLException
with getErrorCode() = 1062).

Does anyone know where to get error codes in postgres (using
jdbc driver: pg73jdbc2ee.jar)?  I know table is set up
correctly because when I try to insert duplicate entry I
get "ERROR:  Cannot insert a duplicate key into unique
index ...".  An SQLException is thrown but getErrorCode()
is 0.

Thanks, any suggestion is much appreciated,
Ken

pgsql-jdbc by date:

Previous
From: Fernando Nasser
Date:
Subject: Re: Is CLOB support?
Next
From: Andrew Sullivan
Date:
Subject: Re: Where's SQL error code???