Extend JdbcTemplate to allow larger batch updates [SPR-7290]

[spring-projects-issues]

Kenny MacLeod opened SPR-7290 and commented

The current implementation of JdbcTemplate can only process JDBC batch updates such that a single batch is sent. This isn't really suitable for very large batches, due to memory constraints.

Please extend this so that you can specify not only the total number of updates, but the maximum size of each batch.

For example, 2,000,000 updates, sent in batches of up to 100,000 each.

---

Affects: 3.0.3

Issue Links:

• JdbcTemplate batch update - Managing batchSize inferior to the number of rows to be updated [SPR-6334] #11000 JdbcTemplate batch update - Managing batchSize inferior to the number of rows to be updated ("duplicates")

[spring-projects-issues]

Thomas Risberg commented

The #11000 issue seems to cover the same topic.

[spring-projects-issues]

Thomas Risberg commented

Please see my comment on #11000

[spring-projects-issues]

Thomas Risberg commented

I've committed the changes contributed for #11000