Is this really a batch update

[Raj Ohadi]

I got this code snippet from web --

   

class Main {
  public static void main(String args[]) throws Exception {
    ApplicationContext ac = new ClassPathXmlApplicationContext("context.xml", Main.class);
    DataSource dataSource = (DataSource) ac.getBean("dataSource");
    // DataSource mysqlDataSource = (DataSource) ac.getBean("mysqlDataSource");

    BatchInsert batchInsert = new BatchInsert(dataSource);
    int count = 5000;
    for (int i = 0; i < count; i++) {
      batchInsert.update(new Object[] { i + 100L, "a" + i, "b" + i, null });
    }
  }
}

class BatchInsert extends BatchSqlUpdate {
  private static final String SQL = "insert into t_customer (id, first_name, last_name, last_login, "
      + "comments) values (?, ?, ?, ?, null)";

  BatchInsert(DataSource dataSource) {
    super(dataSource, SQL);
    declareParameter(new SqlParameter(Types.INTEGER));
    declareParameter(new SqlParameter(Types.VARCHAR));
    declareParameter(new SqlParameter(Types.VARCHAR));
    declareParameter(new SqlParameter(Types.TIMESTAMP));

    setBatchSize(10);
  }

}



 

what confused me is

for (int i = 0; i < count; i++) {
batchInsert.update(new Object[] { i + 100L, "a" + i, "b" + i, null });
}


It seems it is updating the records one by one instead of at batch size. can someone explain this to me ?

[Mark Spritzler]

setBatchSize(10);

Looks like the batch size is set. So after 10 updates, those 10 will be sent to the database in one call. So if you loop 5000 times then you will have 500 database calls based on that batch size.

Mark

[Raj Ohadi]

still don't get it. So what does "update" method exactly do ? when it executes the "updte" on record 1, based on what you said, it does not immediately insert and hold it until record 10 is done with its "update" and then it inserts records 1 to 10 at same time. is that right ?
Then again what does "update" do on record 1 ?

[Mark Spritzler]

Raj Ohadi wrote:still don't get it. So what does "update" method exactly do ? when it executes the "updte" on record 1, based on what you said, it does not immediately insert and hold it until record 10 is done with its "update" and then it inserts records 1 to 10 at same time. is that right ?
Then again what does "update" do on record 1 ?

Yes, exactly. It will hold onto all ten statements then send all ten in one call to the database.

Mark