Examples of org.apache.commons.dbutils.QueryRunner.batch()

Class org.apache.commons.dbutils.QueryRunner

Examples of org.apache.commons.dbutils.QueryRunner.batch()

org.apache.commons.dbutils.QueryRunner.batch()
Execute a batch of SQL INSERT, UPDATE, or DELETE queries. @param conn The Connection to use to run the query. The caller isresponsible for closing this Connection. @param sql The SQL to execute. @param params An array of query replacement parameters. Each row inthis array is one set of batch replacement values. @return The number of rows updated per statement. @throws SQLException if a database access error occurs @since DbUtils 1.1

      params[i] = pearParams(argsList.get(i));
    }
    QueryRunner qr = getQueryRunner();
    logger.trace("BatchUpdate SQL:{}, args size:{}", sql, argsList.size());
    try {
      return qr.batch(sql, params);
    } catch (SQLException e) {
      throw new DataAccessException("BatchUpdate error! sql:" + sql + ";", e);
    }
  }

View Full Code Here

      params[i] = pearParams(argsList.get(i));
    }
    QueryRunner qr = getQueryRunner();
    logger.trace("BatchUpdate SQL:{}, args size:{}", sql, argsList.size());
    try {
      return qr.batch(conn, sql, params);
    } catch (SQLException e) {
      throw new DataAccessException("BatchUpdate error! sql:" + sql + ";", e);
    }
  }

View Full Code Here

        params[17] = updatedAt;
        params[18] = createdAt;
        params[19] = updatedAt;
        allParams.add(params);
      }
      runner.batch(writeConnection, SQL_INSERT_ISSUE, allParams.toArray(new Object[allParams.size()][]));
      insertComments(writeConnection, allComments);
      runner.update(writeConnection, SQL_DELETE_RULE_FAILURES, violationIds);
      writeConnection.commit();
      progress.increment(rows.size());

View Full Code Here

      params[i] = pearParams(argsList.get(i));
    }
    QueryRunner qr = getQueryRunner();
    logger.trace("BatchUpdate SQL:{}, args size:{}", sql, argsList.size());
    try {
      return qr.batch(sql, params);
    } catch (SQLException e) {
      throw new DataAccessException("BatchUpdate error! sql:" + sql + ";", e);
    }
  }

View Full Code Here

      params[i] = pearParams(argsList.get(i));
    }
    QueryRunner qr = getQueryRunner();
    logger.trace("BatchUpdate SQL:{}, args size:{}", sql, argsList.size());
    try {
      return qr.batch(conn, sql, params);
    } catch (SQLException e) {
      throw new DataAccessException("BatchUpdate error! sql:" + sql + ";", e);
    }
  }

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.