jdbc insert using batch get number of successfully inserted rows

Viewed 3582

I am trying to get a correct number of inserted rows for any jdbc (using batch and prepared statement). Now I know 2 ways:

  1. PreparedStatement.getUpdateCount() - But for batches this method returns 1 for every batch even if every row was rejected.

  2. int[] as result of PreparedStatement.executeBatch() and check every element if it is greater than 0. But for some jdbcs (for example Oracle) this array could contain -2 for every record.

So, is there any way to know the number of successfully inserted rows?

1 Answers
Related