Skip site navigation (1) Skip section navigation (2)

Using ON_ERROR_ROLLBACK functionality in JDBC

From: "Koth, Christian (DWBI)" <Christian(dot)Koth(at)smiths-heimann(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Using ON_ERROR_ROLLBACK functionality in JDBC
Date: 2006-07-28 08:39:55
Message-ID: F5F602C218633C419C7BCA6CDDC6E90A02445678@COSSMGMBX04.EMAIL.CORP.TLD (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi all,

I have seen psql has implemented a variable called ON_ERROR_ROLLBACK.
"When on, if a statement in a transaction block generates an error,
the error is ignored and the transaction continues." (from the documentation).

I would need the same functionality using JDBC. So I could continue with my batch
insert even if one or more statements fail. Right now I'm committing the transaction
after each insert.

I have thought of the following:

1. Checking constraints before calling insert. (to slow)
2. Creating a user defined savepoint before each insert,
   and rolling back to this savepoint if the insert fails. (not tried yet)

What would you recommend? Is it possible to set ON_ERROR_ROLLBACK for JDBC transactions?
AFAIK other DBMS do let you continue with you transaction if there was in error.

Thanks,
Chris


******************************************
The information contained in, or attached to, this e-mail, may contain confidential information and is intended solely for the use of the individual or entity to whom they are addressed and may be subject to legal privilege.  If you have received this e-mail in error you should notify the sender immediately by reply e-mail, delete the message from your system and notify your system manager.  Please do not copy it for any purpose, or disclose its contents to any other person.  The views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the company.  The recipient should check this e-mail and any attachments for the presence of viruses.  The company accepts no liability for any damage caused, directly or indirectly, by any virus transmitted in this email.
******************************************

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2006-07-28 08:57:07
Subject: Re: Using ON_ERROR_ROLLBACK functionality in JDBC
Previous:From: Peter NeuDate: 2006-07-27 11:42:24
Subject: Best Way to handle duplicate key exceptions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group