Spring Data JPA: Batch insert for nested entities

by

Make sure to configure Hibernate batch-related properties properly:

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

The point is that successive statements can be batched if they manipulate the same table. If there comes the statement doing insert to another table, the previous batch construction must be interrupted and executed before that statement. With the hibernate.order_inserts property you are giving permission to Hibernate to reorder inserts before constructing batch statements (hibernate.order_updates has the same effect for update statements).

jdbc.batch_size is the maximum batch size that Hibernate will use. Try and analyze different values and pick one that shows best performance in your use cases.

Note that batching of insert statements is disabled if IDENTITY id generator is used.

Specific to MySQL, you have to specify rewriteBatchedStatements=true as part of the connection URL. To make sure that batching is working as expected, add profileSQL=true to inspect the SQL the driver sends to the database. More details here.

If your entities are versioned (for optimistic locking purposes), then in order to utilize batch updates (doesn’t impact inserts) you will have to turn on also:

<property name="hibernate.jdbc.batch_versioned_data">true</property>

With this property you tell Hibernate that the JDBC driver is capable to return the correct count of affected rows when executing batch update (needed to perform the version check). You have to check whether this works properly for your database/jdbc driver. For example, it does not work in Oracle 11 and older Oracle versions.

You may also want to flush and clear the persistence context after each batch to release memory, otherwise all of the managed objects remain in the persistence context until it is closed.

Also, you may find this blog useful as it nicely explains the details of Hibernate batching mechanism.

More Related Contents:

  1. Is it possible to use raw SQL within a Spring Repository
  2. How does the FetchMode work in Spring Data JPA
  3. ImprovedNamingStrategy no longer working in Hibernate 5
  4. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  5. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  6. Refresh and fetch an entity after save (JPA/Spring Data/Hibernate)
  7. Spring JpaRepository – Detach and Attach entity
  8. How to map sql native query result into DTO in spring jpa repository?
  9. Difference between save and saveAndFlush in Spring data jpa
  10. Delete Not Working with JpaRepository
  11. spring data jpa @query and pageable
  12. Apparent connection leak detected with Hikari CP
  13. Why has javax.persistence-api been replaced by jakarta.persistence-api in spring data jpa starter?
  14. Spring Data JPA: How can Query return Non- Entities Objects or List of Objects?
  15. How do you do a limit query in JPQL or HQL?
  16. Hibernate Criteria returns children multiple times with FetchType.EAGER
  17. How can I log SQL statements in Spring Boot?
  18. How to choose the id generation strategy when using JPA and Hibernate
  19. JPQL Create new Object In Select Statement – avoid or embrace?
  20. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  21. @Transactional method called from another method doesn’t obtain a transaction
  22. Spring 3 MVC: one-to-many within a dynamic form (add/remove on create/update)
  23. Hibernate bidirectional @ManyToOne, updating the not owning side not working
  24. How to perform a non-polymorphic HQL query in Hibernate?
  25. How to set a default query timeout with JPA and Hibernate?
  26. Check date between two other dates spring data jpa
  27. javax.transaction.Transactional vs org.springframework.transaction.annotation.Transactional
  28. Spring Data JPA: Query by Example?
  29. Why should anybody put annotations on the getters or setters when using JPA to map the classes?
  30. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR

Leave a Comment