title: executeBatch() locks table when updating
body: <p>I am executing an update with preparedStatement and executebatch like this:</p>
  
  <pre><code>query = "UPDATE BP_PROCESO SET " +
                  "FILTROS = FILTROS||?, " +
                  "COD_ETAPA_RECHAZO= ?," +
                  "APROBADO=? " +
                  "WHERE " +
                  "NIU=? AND " +
                  "COD_CAMPANIA = ?";
          ps = con.prepareStatement(query);
  
  
  Iterator it = registros.entrySet().iterator();
  
  while(it.hasNext()){
  
           int contador = 1;
              ps.setObject(contador++, cadenaFiltro);
              ps.setObject(contador++, etapaRechazo);
              ps.setObject(contador++, 0);
              ps.setObject(contador++, pojo.getNiu());
              ps.setObject(contador++, codigoCampania);
              ps.addBatch();
              if(respuesta %500==0){
                  System.out.println(respuesta);
                  ps.executeBatch();
                  System.out.println("executed");
                  ps.clearBatch();
              }
   }
  </code></pre>
  
  <p>In the first time when ps.executeBatch() the table gets locked, however I am debugging in Apache Tomcat and it does not get locked, the application is installed in Websphere   7.0.0.17, I am getting the connection by JNDI</p>
  
  <p>Does anyone has any idea?</p>