Implementing Bulk Operations

jdbc.batchUpdate(
    "INSERT INTO orders(id, customer_id, total) VALUES (?,?,?)",
    new BatchPreparedStatementSetter() {
        public void setValues(PreparedStatement ps, int i) throws SQLException {
            var o = orders.get(i);
            ps.setObject(1, o.id());
            ps.setObject(2, o.customerId());
            ps.setLong(3, o.totalCents());
        }
        public int getBatchSize() { return orders.size(); }
    });

UPDATE orders SET status = 'archived'
WHERE created_at < now() - interval '180 days'
  AND status = 'completed';

try (var reader = Files.newBufferedReader(path);
     CSVParser p = CSVFormat.DEFAULT.builder().setHeader().build().parse(reader)) {
    var batch = new ArrayList<Order>(1000);
    for (var rec : p) {
        batch.add(toOrder(rec));
        if (batch.size() == 1000) { repo.saveAll(batch); batch.clear(); }
    }
    if (!batch.isEmpty()) repo.saveAll(batch);
}