Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)

[Haifeng Liu]

Hi,

I have a DB writer program written in Java, it do batch updates, and will try to update each record in a batch if it failed. I think no any record in a batch will be update if the batch failed, but weirdly I found a few records update twice(very little amount among all records).

Well, there is less stuff about postgresql jdbc driver. I wanna know if executeBatch really keep all the records in a batch untouched when the batch failed. Any help is appreciate.

[Kevin Grittner]

Post by Haifeng Liu
I wanna know if executeBatch really keep all the records in a
batch untouched when the batch failed.

I recommend asking on the pgsql-jdbc list. You might want to
mention what autoCommit is set to during the attempt.

-Kevin