How to do bulk (multi row) inserts with JpaRepository?

by

To get a bulk insert with Spring Boot and Spring Data JPA you need only two things:

  1. set the option spring.jpa.properties.hibernate.jdbc.batch_size to appropriate value you need (for example: 20).

  2. use saveAll() method of your repo with the list of entities prepared for inserting.

Working example is here.

Regarding the transformation of the insert statement into something like this:

INSERT INTO table VALUES (1, 2), (3, 4), (5, 6)

the such is available in PostgreSQL: you can set the option reWriteBatchedInserts to true in jdbc connection string:

jdbc:postgresql://localhost:5432/db?reWriteBatchedInserts=true

then jdbc driver will do this transformation.

Additional info about batching you can find here.

UPDATED

Demo project in Kotlin: sb-kotlin-batch-insert-demo

UPDATED

Hibernate disables insert batching at the JDBC level transparently if you use an IDENTITY identifier generator.

More Related Contents:

  1. How to use Spring managed Hibernate interceptors in Spring Boot?
  2. Spring Data JPA – Pass column name and value as parameters
  3. How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?
  4. Disable all Database related auto configuration in Spring Boot
  5. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  6. Hibernate field naming issue with Spring Boot (naming strategy)
  7. Spring Data JDBC / Spring Data JPA vs Hibernate
  8. JPA Uppercase table names
  9. Configure Jackson to omit lazy-loading attributes in Spring Boot
  10. Spring Boot + JPA2 + Hibernate – enable second level cache
  11. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  12. Apparent connection leak detected with Hikari CP
  13. Spring Boot Data JPA – Modifying update query – Refresh persistence context
  14. Why has javax.persistence-api been replaced by jakarta.persistence-api in spring data jpa starter?
  15. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  16. Spring Boot – Handle to Hibernate SessionFactory
  17. Hibernate Criteria Join with 3 Tables
  18. Unable to get spring boot to automatically create database schema
  19. How to maintain bi-directional relationships with Spring Data REST and JPA?
  20. Hibernate Search: How to use wildcards correctly?
  21. How to use the Java 8 LocalDateTime with JPA and Hibernate
  22. Entity Class name is transformed into SQL table name with underscores
  23. Hibernate: How specify custom sequence generator class name using annotations?
  24. Filtering data with Spring boot CrudRepository
  25. Deleted object would be re-saved by cascade (remove deleted object from associations)
  26. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  27. Delete Not Working with JpaRepository
  28. When to Use EntityManager.clear()?
  29. What is the right way to use spring MVC with Hibernate in DAO, service layer architecture
  30. Hibernate hbm2ddl.auto, possible values, and what they do

Leave a Comment