title: java commit inside for loop
body: <p>what are the advantage/disadvantage of using commit inside for loop in JAVA ?</p>
  
  <pre><code>for(int cnt = 0; cnt &lt; pdbResponseVOList.size(); cnt++) {
      //UPDATE STATEMENT
      stmt = vSqlConnection.prepareStatement(vUpdateProvisioningTable);
      int vUpdateSucess = stmt.executeUpdate();
      vSqlConnection.commit();
  } //end for loop
  //stmt.close()
  // vS
  
  qlConnection.close()
  </code></pre>