batch update as a single transaction

Thread view:

John Harrison - 30 Sep 2004 18:12 GMT

Hi,

I'm doing a JDBC batch update, writing several thousand rows to a single
table. As I understand it a batch update can partially succeed, so some of
my rows might get written and some not. I'd like the batch update to either
fully succeed or completely fail, commit or rollback in other words. Is that
easy to do? I'm pretty new at this.

Thanks,
John

Reply to this Message

Joe Weinstein - 30 Sep 2004 18:57 GMT

> Hi,
>
[quoted text clipped - 3 lines]
> fully succeed or completely fail, commit or rollback in other words. Is that
> easy to do? I'm pretty new at this.

Yes, easy. Set autoCommit(false) on the connection (so any subsequent work
needs to be committed). Then do batch. Check return array or whatever else
you need to do to verify whether everything went OK. If it did, call commit()
on the connection, else call rollback().

Joe Weinstein at BEA

> Thanks,
> John

Reply to this Message

John Harrison - 30 Sep 2004 19:05 GMT

> > Hi,
> >
[quoted text clipped - 8 lines]
> you need to do to verify whether everything went OK. If it did, call commit()
> on the connection, else call rollback().

OK thanks, amazingly enough that was what I was doing already.

john

Reply to this Message

batch update as a single transaction

Free Magazines