JDBC SQLCodes or Error Numbers - Or how to handle errors

From: User One <user1(at)fictionary(dot)org>
To: PGSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: JDBC SQLCodes or Error Numbers - Or how to handle errors
Date: 2001-10-28 07:33:07
Message-ID: 3BDBB4B3.62A1E600@fictionary.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm new to postgresql and it's JDBC driver, although an old hand a
relation databases. I'm trying to rely on past practices in developing
some code using Java and postgresql.

I'm trying to do a INSERT into a table with the full knowledge that I
might be trying to insert a duplicate row (which won't be allowed by the
Primary Key). Since 80% of the inserts will succeed (because I don't
expect many duplicates) I didn't want to waste programming time or
runtime by doing a select to first see if the data existed. I'm used to
just doing the insert and catching the SQLCODE -803 on DB2 to know that
the row I'm trying to insert already exists.

Is there an easy way to do this using Postgresql and JDBC?

Postgresql version is 7.1.3
JDBC driver is the one that I compiled from the 7.1.3 installation

I'm using the Java SDK 1.3.1_01

-- So is my only hope trying to "match" the error text and determine
what when wrong?

Thanks,
Henry

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Rene Pijlman 2001-10-28 08:55:54 Re: JDBC SQLCodes or Error Numbers - Or how to handle errors
Previous Message Jason Davies 2001-10-28 00:25:49 DatabaseMetaData.getTables()