SQLException in iteration and loop doesn't continue

[Gaurav Chikara]

Dear All
I have been stuck with this weird problem
In side a loop I have try catch block and for testing purpose I am explicitly throwing an SQLException on particular iteration and want the logic to continue the loop after recording the iteration no where Exception was thrown but It breaks out of the loop and comes in outer finally block
I am posting my code.If any one can give me an idea where I am wrong it will be of great help

try{
    
//conn.setAutoCommit(true);
pstmt = conn.prepareStatement("INSERT INTO VT_RE_TXN (TXNID, TXNNAME) VALUES (?,?)");
    int finalThreshold = 0;
int threshold=0;
    
// If threshold value passed is 0 that means that
// we are in last check which is less than batch therefore
// it has to belooped ffrom failed index to end of the list 
    if(thresholdValue==0){
finalThreshold = insertList.size();
    }
    else {
finalThreshold=thresholdValue;
    }
    
    
for(int i=fromIndex;i<finalThreshold;i++){ 
toBeInsertedDTO = (AuthTransactionDTO)insertList.get(i);
currentTxnId=i;


pstmt.setInt(1,currentTxnId);
pstmt.setString(2,Util.emptyToNull(Util.formatId(toBeInsertedDTO.getTransactionName())));
 
try{
if(i==4) throw new SQLException();
pstmt.execute();
conn.commit(); 
}
catch(SQLException se1){
VLogger.logError(se1.getMessage(), se1);
VLogger.logInfo("Ignoring the Exception inside the addHeaderWithoutBatch"); 
continue;[B]<--Writing continue here also  doesn't seems to help[/B]
}
}// for 
    }// try block ends here
    
catch (SQLException e) {
VLogger.logError(e.getMessage()+"in method addHeaderWithoutBatch at the  "+currentTxnId +" iteration", e);
throw new DAOException(e.getMessage()+" in method addHeaderWithoutBatch at the "+currentTxnId +" iteration", e);
}
finally {
   currentTxnId++;    [B]<-- Control comes here after exiting from loop[/B]
   closeQuitely(null,pstmt,null);
   try{
conn.setAutoCommit(false);
   }
   catch(SQLException se) {
VLogger.logError(se.getMessage()+"in method addHeaderWithoutBatch while setting autoCommit",se);
   }
   
   return currentTxnId;
}
 

    

[Suman Sharma]

I think it has to do with the scope of the i variable which is for loop, not try block. So when i==4, it comes out of for loop. Instead of using try-catch block, other ways like printing messages when i==4 can be used, then continue the next loop. I hope this helps.