Batch insert

Feature 14: save many rows at once, in one transaction. If one row fails, nothing is saved (rollback).

JdbcTemplate.batchUpdate vs JPA saveAll()

1 · Rows to insert

Paste CSV Generate test rows

CSV: code,title,category,priority,tags,summary

The header line is optional. Quote fields that contain commas: "java, sql". An empty code gets the next ART-xxxx. Up to 5000 rows.

2 · How to save them

JDBC batch One prepared INSERT, rows sent 500 at a time with jdbc.batchUpdate(). Fast.

JPA saveAll() One INSERT per row: IDENTITY ids make Hibernate insert row by row to learn each id.

Skip rows whose code already exists (otherwise a duplicate code rolls back the whole batch)

See the newest articles

JavaBatchInsertService

jdbc.batchUpdate(INSERT_SQL, rows, 500, (ps, r) -> {
    ps.setString(1, r.code());
    ps.setString(2, r.title());
    ...
});

// or, with JPA:
repo.saveAll(entities);
repo.flush();

The method is @Transactional: a duplicate code throws, and every row of the batch is rolled back.
SQL Server allows at most 2100 parameters per statement, so the "already exists?" check runs WHERE code IN (…) in chunks of 1000.
Try to insert the sample CSV twice: the second time fails, unless you tick "Skip rows…".

Batch insert

SQL behind this page