@ExpectJdbcBatching

Verifies that insert, delete and update statements are processed in JDBC batches having batchSize elements.

Batching of inserts, updates and deletes statements allows to reduce the number of roundtrips to the database which can dramatically impact application performance.

You may sometimes think that you are using JDBC batching but in fact not: Paper 1, Paper 2.

🔧 Elements

Name	Type	Meaning	Default value
batchSize	int	JDBC batch size	-

batchSize is optional. In this case, the annotation checks that insert, delete and update statements are processed in JDBC batches but the annotation does not check the batch size.

A 0 batch size means that JDBC batching is disabled.

🔎 Example

    @ExpectJdbcBatching(batchSize = 30)