Issue:
1)If we try to execute 5000 statements using
java batch update by preparedstatements on oracle database , is there any chance to track the statement which has issues while executing that batch update
below code adds all the insert statements into prepared statement and executes the batch once the count reaches 5000 count
this the code i was using
ps.addBatch();
batchCtr++;
if(batchCtr >= 5000){
int[] count= ps.executeBatch();
log.info("Executed the count using batch"+count.length+"projectnumber--"+str);
batchCtr = 0;
}