Examples of org.springframework.jdbc.core.BatchPreparedStatementSetter

org.springframework.jdbc.core.BatchPreparedStatementSetter
Batch update callback interface used by the {@link JdbcTemplate} class.
This interface sets values on a {@link java.sql.PreparedStatement} providedby the JdbcTemplate class, for each of a number of updates in a batch using the same SQL. Implementations are responsible for setting any necessary parameters. SQL with placeholders will already have been supplied.
Implementations do not need to concern themselves with SQLExceptions that may be thrown from operations they attempt. The JdbcTemplate class will catch and handle SQLExceptions appropriately. @author Rod Johnson @since March 2, 2003 @see JdbcTemplate#batchUpdate(String,BatchPreparedStatementSetter) @see InterruptibleBatchPreparedStatementSetter

      int start = i * this.batchSize;
      int end = (i + 1) * this.batchSize;
      if (end > l.size())
        end = l.size();
      final List<T> chunkList = l.subList(start, end);
      jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {


        @Override
        public int getBatchSize() {
          return chunkList.size();
        }

View Full Code Here

     *
     * @param acl containing the ACEs to insert
     */
    protected void createEntries(final MutableAcl acl) {
        jdbcTemplate.batchUpdate(insertEntry,
            new BatchPreparedStatementSetter() {
                public int getBatchSize() {
                    return acl.getEntries().size();
                }


                public void setValues(PreparedStatement stmt, int i) throws SQLException {

View Full Code Here

  @Override
  public void write(final List<? extends T> items) {
    final ListIterator<? extends T> itemIterator = items.listIterator();


    getJdbcTemplate().batchUpdate("INSERT into BATCH_STAGING (ID, JOB_ID, VALUE, PROCESSED) values (?,?,?,?)",
        new BatchPreparedStatementSetter() {
      @Override
      public int getBatchSize() {
        return items.size();
      }

View Full Code Here

      return new int[] {0};
    }
    String sqlToUse = NamedParameterUtils.substituteNamedParameters(parsedSql, batchArgs[0]);
    return jdbcOperations.batchUpdate(
        sqlToUse,
        new BatchPreparedStatementSetter() {


          @Override
          public void setValues(PreparedStatement ps, int i) throws SQLException {
            Object[] values = NamedParameterUtils.buildValueArray(parsedSql, batchArgs[i], null);
            int[] columnTypes = NamedParameterUtils.buildSqlTypeArray(parsedSql, batchArgs[i]);

View Full Code Here

  private int[] executeBatchInternal(final List<Object>[] batchValues) {
    if (logger.isDebugEnabled()) {
      logger.debug("Executing statement " + getInsertString() + " with batch of size: " + batchValues.length);
    }
    return getJdbcTemplate().batchUpdate(getInsertString(),
        new BatchPreparedStatementSetter() {
          @Override
          public void setValues(PreparedStatement ps, int i) throws SQLException {
            List<Object> values = batchValues[i];
            setParameterValues(ps, values, getInsertTypes());
          }

View Full Code Here

    if (logger.isDebugEnabled()) {
      logger.debug("Executing statement " + getInsertString() + " with batch of size: " + batchValues.length);
    }
    int[] updateCounts = jdbcTemplate.batchUpdate(
        getInsertString(),
        new BatchPreparedStatementSetter() {


          public void setValues(PreparedStatement ps, int i) throws SQLException {
            List<Object> values = batchValues[i];
            setParameterValues(ps, values, getInsertTypes());
          }

View Full Code Here

      return new int[] {0};
    }
    String sqlToUse = NamedParameterUtils.substituteNamedParameters(parsedSql, batchArgs[0]);
    return jdbcOperations.batchUpdate(
        sqlToUse,
        new BatchPreparedStatementSetter() {


          public void setValues(PreparedStatement ps, int i) throws SQLException {
            Object[] values = NamedParameterUtils.buildValueArray(parsedSql, batchArgs[i], null);
            int[] columnTypes = NamedParameterUtils.buildSqlTypeArray(parsedSql, batchArgs[i]);
            setStatementParameters(values, ps, columnTypes);

View Full Code Here

      return new int[0];
    }
    
    int[] rowsAffected = getJdbcTemplate().batchUpdate(
        getSql(),
        new BatchPreparedStatementSetter() {
          public int getBatchSize() {
            return parameterQueue.size();
          }
          public void setValues(PreparedStatement ps, int index) throws SQLException {
            Object[] params = parameterQueue.removeFirst();

View Full Code Here

    if (logger.isDebugEnabled()) {
      logger.debug("Executing statement " + getInsertString() + " with batch of size: " + batchValues.length);
    }
    int[] updateCounts = jdbcTemplate.batchUpdate(
        getInsertString(),
        new BatchPreparedStatementSetter() {


          public void setValues(PreparedStatement ps, int i) throws SQLException {
            List<Object> values = batchValues[i];
            setParameterValues(ps, values, getInsertTypes());
          }

View Full Code Here

   */
  private void persistSerializedContexts(final Map<Long, String> serializedContexts, String sql) {
        if (!serializedContexts.isEmpty()) {
            final Iterator<Long> executionIdIterator = serializedContexts.keySet().iterator();


            getJdbcTemplate().batchUpdate(getQuery(sql), new BatchPreparedStatementSetter() {
                @Override
                public void setValues(PreparedStatement ps, int i) throws SQLException {
                    Long executionId = executionIdIterator.next();
                    String serializedContext = serializedContexts.get(executionId);
                    String shortContext;

View Full Code Here

0 1 2 3 4

TOP

Related Classes of org.springframework.jdbc.core.BatchPreparedStatementSetter

aim.dao.impl.BlankPolicyDAOImpl

com.alibaba.otter.node.etl.common.db.DbPerfIntergration

com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker

com.alibaba.otter.node.etl.load.loader.db.interceptor.operation.AbstractOperationInterceptor

com.defaultcompany.external.repository.ApproverDAO

com.lingbobu.flashdb.transfer.impl.OutputMySQL

com.serotonin.m2m2.gviews.GraphicalViewDao

com.serotonin.m2m2.watchlist.WatchListDao

com.skyline.base.dao.impl.BaseDaoImpl

com.skyline.energy.provider.spring.BatchPreparedStatementSetterCreator

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.