Re: jdbc batch insert

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