Examples of org.springframework.jdbc.core.InterruptibleBatchPreparedStatementSetter

org.springframework.jdbc.core.InterruptibleBatchPreparedStatementSetter

Extension of the {@link BatchPreparedStatementSetter} interface,adding a batch exhaustion check.

This interface allows you to signal the end of a batch rather than having to determine the exact batch size upfront. Batch size is still being honored but it is now the maximum size of the batch.

The {@link #isBatchExhausted} method is called after each call to{@link #setValues} to determine whether there were some values added,or if the batch was determined to be complete and no additional values were provided during the last call to setValues.

Consider extending the {@link org.springframework.jdbc.core.support.AbstractInterruptibleBatchPreparedStatementSetter}base class instead of implementing this interface directly, using a single setValuesIfAvailable callback method that checks for available values and sets them, returning whether values have actually been provided. @author Thomas Risberg @author Juergen Hoeller @since 2.0 @see JdbcTemplate#batchUpdate(String,BatchPreparedStatementSetter) @see org.springframework.jdbc.core.support.AbstractInterruptibleBatchPreparedStatementSetter


      @Override
      public int[] doInPreparedStatement(PreparedStatement ps) throws SQLException {
        try {
          int batchSize = pss.getBatchSize();
          InterruptibleBatchPreparedStatementSetter ipss = null;
          if (pss instanceof InterruptibleBatchPreparedStatementSetter) {
            ipss = (InterruptibleBatchPreparedStatementSetter) pss;
          }
          if (JdbcUtils.supportsBatchUpdates(ps.getConnection())) {
            for (int i = 0; i < batchSize; i++) {
              pss.setValues(ps, i);
              if (ipss != null && ipss.isBatchExhausted(i)) {
                break;
              }
              ps.addBatch();
            }
            int[] rows = ps.executeBatch();
            return processResult(ps, rows, true);
          } else {
            List<Integer> rowsAffected = new ArrayList<Integer>();
            int[] rows = new int[1];
            for (int i = 0; i < batchSize; i++) {
              pss.setValues(ps, i);
              if (ipss != null && ipss.isBatchExhausted(i)) {
                break;
              }
              int rowAffected = ps.executeUpdate();
              rows[0] = rowAffected;
              rowsAffected.add(rowAffected);

Examples of org.springframework.jdbc.core.InterruptibleBatchPreparedStatementSetter

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