Thread: jdbc batch insert
Hi
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
int[] updateStatus = preparedStatement.executeBatch();
I get as many array entries as the number of rows inserted.
I use postgres 8.1.2 with the 8.1.404 driver.
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