Batch processing fails in Oracle. Find out which statement in the batch is causing it

[Flowers]

I am extracting data from excel sheet and inserting them into my oracle table. The database is setup in a way that when executing a batch statement, if any insert statement in the batch fails, all the other statements in the batch are not executed. So my problem is how can I find out which row of data is actually causing it, so I can send a message to the user with the row number of the data that's causing the problem? \[code\]Connection con = null; PreparedStatement pstmt = null; Iterator iterator = list.iterator(); int rowCount = list.size(); int currentRow = 0; String sqlStatement = "INSERT INTO DMD_VOL_UPLOAD (ORIGIN, DESTINATION, DAY_OF_WEEK, VOLUME)"; sqlStatement += " VALUES(?, ?, ?, ?)";int batchSize==1000;for(currentRow=1; currentRow<=rowCount; currentRow++){ ForecastBatch forecastBatch = (ForecastBatch) iterator.next(); pstmt.setString(1, forecastBatch.getOrigin()); pstmt.setString(2, forecastBatch.getDestination()); pstmt.setInt(3, forecastBatch.getDayOfWeek()); pstmt.setInt(4, forecastBatch.getVolumeSum()); pstmt.addBatch(); if(i % batchSize == 0){ updateCounts = pstmt.executeBatch(); con.commit(); pstmt.clearBatch(); session.flush(); session.clear(); } }\[/code\]