Re: jdbc batch insert

[Kris Jurka <books(at)ejurka(dot)com>]

On Fri, 29 Sep 2006, Sriram Dandapani wrote:

> I have a problem where the batch inserts behave as if the transactions
> were done on a single row by single row basis. When I check the return
> value of the batch update

Transactions and affected row counts have nothing to do with each other.

> int[]  updateStatus = preparedStatement.executeBatch();
>
> I get as many array entries as the number of rows inserted.

That's what the JDBC spec says you should get.  Consider if your batches 
were instead "UPDATE TAB SET x= ? WHERE y = ?".  Depending on your y value 
you would get a different number of updated rows, so you need one affected 
row count per batch entry.

Kris Jurka