problem in inserting data using executebatch

[vijayz devraj]

hi
iam using beans here
iam storing the data in arrayList object and iterating it.

  
while(xldataiterator.hasNext()){
pstmt = myConnection.prepareStatement("insert into xxxx values(?,?,?,?)");
pstmt.setString(1, xlformdataget.getEmail());
 
------
-----
-----
pstmt.addBatch(); ///adding to batch
}
 
int[] updateCounts = pstmt.executeBatch();
processUpdateCounts(updateCounts);
}
 
public static void processUpdateCounts(int[] updateCounts) {
        for (int i=0; i<updateCounts.length; i++) {
            if (updateCounts[i] >= 0) 
s.o.p("Successfully executed; the number represents number of affected rows");
            } else if (updateCounts[i] == Statement.SUCCESS_NO_INFO) {
s.o.p("Successfully executed; number of affected rows not available");
            } else if (updateCounts[i] == Statement.EXECUTE_FAILED) {
s.o.p("Failed to execute");
           }         }      }
  

iam able to insert only the last record but not all the records.. can you guide me.......

[Joe Ess]

Please don't post the same question more than once. It causes confusion and duplication of effort as the community tries to help everyone.
CarefullyChooseOneForum