Add a batchUpdate method to namedParameterJdbcTemplate [SPR-3322]

[spring-projects-issues]

Mark St. John opened SPR-3322 and commented

To add batch updating support to NamedParameterJdbcTemplate, the following method could be added to it:
public void batchUpdate(String sql, NamedParameterBatchPreparedStatementSetter npbpss) throws DataAccessException

NamedParameterBatchPreparedStatementSetter would be a new Interface that behaves like BatchPreparedStatement except that its setValues method would look like the following:
public void setValues(PreparedStatement ps, Map<String, Object[]> paramMap)

paramMap would contain the parameter name as the key, and an array of objects to substitute as the value

---

Issue Links:

• Discrepancy between sql parsing in SimpleJdbcTemplate and NamedParameterJdbcTemplate when doing batchUpdates [SPR-5162] #9835 Discrepancy between sql parsing in SimpleJdbcTemplate and NamedParameterJdbcTemplate when doing batchUpdates

Referenced from: commits 4105957, 0d5c9c1, f4e75de

1 votes, 2 watchers

[spring-projects-issues]

Toshifumi Kato commented

I agree.
It would be great to have batchUpdate added to NamedParameterJdbcTemplate.

[spring-projects-issues]

Thomas Risberg commented

I added two batchUpdate methods - one takes an array of Maps containing the batch parameter values; the other one takes an array of SqlParameterSource objects for the batch.