inconsistant save MSSQL

["Sandeep S. Chhikara" <sc...@inventes.com>]

Hi all, 

I am experiencing inconsistant results with save() method,  call to save() does not save results sometimes. 
This failure is inconsistant and has been observed multiple times a day. Lets say typically of 2000 rows data will be save correctly and 
for 1 or 2 or more it might not be saved. 

Environment: Web application on TOMCAT, 
torque 3.1 
database: MSSQL

Table schema is simple, each table/Tables have ID columns as primary keys. All tables have similiar structure and only problem in in one of tables. 
The web application has multiple threads (created by developers) , and all api's callling  Torque save() have been synchronized. 

This failure to save occurs inconsistantly in some rows while for most it works.

Please suggest solution. 

thanks in advance
Sandeep

--------------------code snippet 
    Criteria crit = new Criteria();    
    crit.add(TransformJobPeer.TRANSFORM_JOB_ID,tji.getTranformJobId().longValue());
    List v = TransformJobPeer.doSelect(crit);  
    Iterator itr = v.iterator();
     TransformJob lkup;
    BigInteger jobId = tji.getTranformJobId();
      
      Iterator lItr;
      TransformJobFilesInterface tjfi;
  
    while(itr.hasNext()){
     lkup = (TransformJob)itr.next();
     try{
      logger.error("TESTING : data from Db ID:" + tji.getTranformJobId() + ".STATUS:" + tji.getStatus());       
       lkup.setDateLastUpdated(new Date());     
       lkup.setStatus(tji.getStatus());
       lkup.setIsComplete(true);

       logText = lkup.getLogText();
       
       if(null == logText)
        logText = tji.getLogText();
       else
        logText= logText + tji.getLogText();
       lkup.setLogText(logText);
       
       lkup.save();
    }catch....
----------------------------------------





table schema:
 <table name="TRANFORM_JOB" 
        idMethod="native">
       <column name="JOB_ID"
         required="true"
         primaryKey="true"
         type="BIGINT"
         identity="true"
         autoIncrement="true"
         javaType="Object"
         description="job table"/>
         <column
               name="NUM_FILES"            
               type="INTEGER"            
         description="number of files"/>          
         <column
        name="NUM_TRIES"            
        type="INTEGER"            
        javaName="numberTry"
         description="number of tries done"/>
         <column
               name="isJobComplete"            
               type="BIT"            
               javaName="isComplete"
         description="isJobComplete"/>           
       <column
         name="BATCH_DATE"            
         type="CHAR" 
         size="8"
         javaName="batchDate"
         description="date in format yyyymmdd"/>
          <column
   name="DEST_DIR_PATH"
   type="VARCHAR"
   size="512"
   javaName="destDirPath"
         description="dest path"/>   
         <column
     name="errorReason"
     type="CHAR"
     size="25"
     javaName="errorReason"
  description="errorReason"/>  
        <column
          name="LOG_TEXT"
          type="LONGVARCHAR" 
          javaName="logText"
         description="log "/>
           <column
                name="DATE_FILED"            
                type="DATE"             
                javaName="dateFiled"
                description="time stamp"/>                      
              <column
                name="DATE_RECEIVED"            
                type="DATE"             
                javaName="dateReceived"
           description="time stamp"/>                 
        <column
               name="DATE_CREATED"            
               type="DATE"             
               javaName="dateCreated"
         description="time stamp"/>   
<some foreign key defs> 
</table>