Postgres Pro
Downloads
Home   >   mailing lists

Best Way to handle duplicate key exceptions - Mailing list pgsql-jdbc

From Peter Neu
Subject Best Way to handle duplicate key exceptions
Date
Msg-id 002001c6b171$ba67e670$bcc8a8c0@PCMELZER
Whole thread Raw
In response to Re: Simple way to manage users with JDBC/Servlets?  (Roland Walter <rwa@mosaic-ag.com>)
List pgsql-jdbc
Tree view 
Hello,

what is he best way to handle duplicate key exceptions? When I do bulk
import I don't want
the insert process to fail simply because somebody gave me an inconsistent
csv file.

Is there simple way to tell Postgres to simply insert everything that is
good and let me log the errors?

Cheers,
Pete

pgsql-jdbc by date:

Previous
From: Roland Walter
Date:
Subject: Re: Simple way to manage users with JDBC/Servlets?
Next
From: "Koth, Christian (DWBI)"
Date:
Subject: Using ON_ERROR_ROLLBACK functionality in JDBC