set commit size in spring

[Shah Hiren]

i have a list of 500,000 records .i am using the batch update code to insert data in database.Should i send those many records in a single batch insert? or i should use commit size to commit at interval of say 50000.how can i set commit size?

try 
    {
                 strInsertQry = "INSERT INTO file_upload_tbl_xm"
                            + "(rec_id,fupload_id)"
                            + "values" + "(UPLOAD_S.nextval,"
                            + " ? " // 
                            +  ")";

                 getJdbcTemplate().getDataSource().getConnection().setAutoCommit(false);
         	
                
                 int[] updateCounts = getJdbcTemplate().batchUpdate(strInsertQry,new BatchPreparedStatementSetter() 
       		  {
                       public void setValues(PreparedStatement ps, int i) throws SQLException {
                    	   FileDataDTO dataDTO = (FileDataDTO)lstSqlFinalData.get(i);
                    	   ps.setInt(1,dataDTO.getIntFuploadId());
        
                       }
                       public int getBatchSize() {
							return lstSqlFinalData.size();
                       }
                   } );
                 //intResult = updateCounts[0];
//                 getJdbcTemplate().getDataSource().getConnection().commit();
                 return true;  
          }

[Mark Spritzler]

Isn't that what

public int getBatchSize() {
return lstSqlFinalData.size();
}

is doing? Setting the batch/commit size.

Now the question comes in what Use Case in an application needs you to insert 500,000 records into another database? Maybe look into Spring Batch to do batch processing, or maybe some ETL tool out there that does massive table inserts.

Mark