batch size

[mistrz_7]

Hello,

I load huge csv file to db using Jberet. I think that jdbcItemWriter commits every 40 or 50 records. Is it possible to change batch/commit size? I would like to commit every 3000.

Regards

sw

[cfang]

The jdbc batch insert size is the same as the step item-count value.  jdbcItemWriter just add all items in a chunk to the prepared statement.  The underlying jdbc driver may impose some limits on the batch insert size and split it further up.

In your app, is the step item-count consistent with the jdbc insert batch size?

[mistrz_7]

Thank. Now I understand how it works.