Hello,
Could you please help me out on this issue.
executeBatch is always returning zero.
Could you please look into this code and reply me ASAP. I have an urgency.


MyCode:
public int updtFlCntList(ArrayList docCnts)throws  FileContentException
        {
                int updCount = 0;
                try 
                {
                        sqlMap.startTransaction();
                        sqlMap.startBatch();
                        for (int i=0;i<docCnts.size();i++)
                        {
                                
System.out.println("updtFlCntList"+((Document)docCnts.get(i)).toString());
                                
sqlMap.update("updtFlCntsList",(Document)docCnts.get(i));
                                
                        }
                         updCount = sqlMap.executeBatch();
                         System.out.println("updCount:-"+updCount);
                        sqlMap.commitTransaction();
                }
                catch (SQLException e)
                {
                        try 
                        {
                                sqlMap.endTransaction(); 
                        } 
                        catch(SQLException se) 
                        {
                                throw new RuntimeException("SQLException:"+se);
                        }
                        logger.debug(e.getMessage());
                        throw new FileContentException(e.getMessage());
                }
                finally
                {
                        try 
                        {
                                sqlMap.endTransaction(); 
                        } 
                        catch(SQLException se) 
                        {
                                throw new RuntimeException("SQLException:"+se);
                        }
                }
                return updCount;
                
        }

Thanks,
Sruthi Krishnamoorthi
703-562-9732(Work)
537 A - (Raytheon) Location 


Reply via email to