How do you enable batch inserts in hibernate?

rogerdpack picture rogerdpack · Aug 17, 2012 · Viewed 29.3k times · Source

With hibernate, when I attempt to enable batch inserts with

  <property name="jdbc.batch_size">50</property>

I get the following output:

 [...] cfg.SettingsFactory INFO  - JDBC batch updates for versioned data: disabled
 [...] cfg.SettingsFactory INFO  - Order SQL inserts for batching: disabled

And then this:

 [...] jdbc.AbstractBatcher DEBUG - Executing batch size: 1

never more than batch size: 1 basically.

Am I missing a setting?

Answer

Vlad Mihalcea picture Vlad Mihalcea · Mar 19, 2015

To enable batching for both INSERT and UPDATE statements, you need to sett all the following Hibernate properties:

<property name="hibernate.jdbc.batch_size">30</property>
<property name="hibernate.order_inserts">true</property>
<property name="hibernate.order_updates">true</property>
<property name="hibernate.jdbc.batch_versioned_data">true</property>

If you can use a SEQUENCE, then you should not use IDENTITY generators, since it disables batch fetching.

If you cannot use a SEQUENCE (e.g. MySQL), then try using a separate mechanism to enable batch inserts (e.g. jOOQ) instead of using the TABLE generator which does not scale and has a high-performance penalty.