Processing 100,000 records update in a jdbc batch

Question

I am inserting 132,000 records in a database table using jdbc batch of prepated statement. The problem i am facing is all records are not inserted in to table only records 1444 are inserted.

try{
        StringBuffer insert = new StringBuffer("INSERT INTO mytable (field1,field2,
,field3,field 4 )   VALUES ( ?, ?, ?, ? )");

          pstmt = conn.prepareStatement(insert.toString());
          Iterator cptIcd9Iterator = cptIcd9List.iterator();    
          while(cptIcd9Iterator.hasNext()){
              cptIcd9VO = (CptIcd9VO)cptIcd9Iterator.next();            
              count++;
              pstmt.setString(1, "field1");
              pstmt.setString(2, "field2");
              pstmt.setString(3, "field3");
              pstmt.setInt(4, 4);
              pstmt.addBatch();
          }
           updateCounts = pstmt.executeBatch();
    }
    catch (Exception e) {
        logger.error(e);
   }

Can anyone help me ?

you're not giving enough information, does it produce an error along the way for example? — Matt, Feb 02 '11 at 10:32
No it does not give any error. It quits normally without any exception or error — Zeeshan, Feb 02 '11 at 11:21
what's in updateCounts at the end? does this flag success for 1444 rows only? — Matt, Feb 02 '11 at 11:41

score 2 · Accepted Answer · edited May 23 '17 at 11:55

2

You can't insert all of them in one go, you must do it step by step.

Read this SO post.

edited May 23 '17 at 11:55

Community

1
1

answered Feb 02 '11 at 09:51

darioo

43,550
10
71
102

Processing 100,000 records update in a jdbc batch

1 Answers1