executeBatch() and operation after error

From: "Heiko W(dot)Rupp" <heiko(dot)rupp(at)redhat(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: executeBatch() and operation after error
Date: 2007-01-15 11:13:07
Message-ID: FDFED6B5-8888-4B85-8D4F-5C133CF23392@redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

JDBC 3.0 spec speifies that in 15.1.3 a driver may continue
processing statements in a batch
if one of the statements throws an error.

Is this supported by the current driver? If yes, how can I enable this?

I have a use case where most of the time my application would very
much benefit from
using batches, but where sometimes the data to be inserted is already
there.

Of course there is the workaround to check for a BatchException and
then doing a
getUpdateCounts() to fall back inserting everyhing 'by hand'. But
obviously it is desirable
for e.g. a batch of 10 to only process statement #2 if this is
failing and having all other
statements be treated by the batching

Heiko

--
Heiko W.Rupp
heiko(dot)rupp(at)redhat(dot)com, http://www.dpunkt.de/buch/3-89864-429-4.html

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2007-01-15 12:24:31 Re: executeBatch() and operation after error
Previous Message Kris Jurka 2007-01-14 06:37:37 Re: Problem with JDBC version 8.0/1 vs. 7.4