Spring Data JPA saveAll not doing batch insert

Question

So I'm using a simple JpaRepository and the saveAll() method is called.

hibernate.jdbc.batch_size = 500
hibernate.order_inserts = true
hibernate.generate_statistics = true

After running the application:

   8045055 nanoseconds spent acquiring 1 JDBC connections;
    0 nanoseconds spent releasing 0 JDBC connections;
    137189246 nanoseconds spent preparing 1158 JDBC statements;
    1417689514 nanoseconds spent executing 1158 JDBC statements;
    0 nanoseconds spent executing 0 JDBC batches;
    0 nanoseconds spent performing 0 L2C puts;
    0 nanoseconds spent performing 0 L2C hits;
    0 nanoseconds spent performing 0 L2C misses;
    16270990 nanoseconds spent executing 1 flushes (flushing a total of 1158 entities and 0 collections);
    0 nanoseconds spent executing 0 partial-flushes (flushing a total of 0 entities and 0 collections)

Can anyone see a reason for 0 having JDBC batches executed? Also, I have to point that my entity has @GeneratedValue(strategy = IDENTITY) primary key

[Hibernate disables insert batching at the JDBC level transparently if you use an identity identifier generator.](https://docs.jboss.org/hibernate/orm/current/userguide/html_single/Hibernate_User_Guide.html#batch-session-batch) — Cepr0, Nov 23 '19 at 21:20
you the real MVP. This should be the accepted answer, but you posted a comment — UnguruBulan, Nov 25 '19 at 08:59
Maybe [this](https://stackoverflow.com/a/50882952/5380322) my answer about batch insert will be also interesting for you... — Cepr0, Nov 25 '19 at 09:34
I'm using a UUID generator on my entities and but I'm using the .save() method for a non-bulk insert and I'm still seeing the same issue? — ennth, May 20 '21 at 22:27

score 7 · Accepted Answer · answered Nov 25 '19 at 09:02

7

Hibernate doesn't perform insert batching with the identity identifier generator. More info is here.

answered Nov 25 '19 at 09:02

Cepr0

24,708
7
67
95

1

in my case with oracle insert batching doesn't happen with any of the id generation strategies. and yes i have set the property `hibernate.jdbc.batch_size: 100` – raven Aug 11 '21 at 07:42
Does batch insert work when we are setting the Id manually? – Sumit Desai Mar 28 '22 at 07:34

score 1 · Answer 2 · answered Nov 22 '19 at 22:02

1

Set hibernate.order_updates = true also.

Change the logger for org.hibernate.engine.jdbc.batch.internal.BatchingBatch to DEBUG and see what output you are getting.

answered Nov 22 '19 at 22:02

Chris Savory

2,359
1
15
23

Where do you set this? – ennth May 20 '21 at 22:38

score 1 · Answer 3 · answered Nov 23 '19 at 13:08

1

Add prefix spring.jpa.properties to property names. It should look like this:

spring.jpa.properties.hibernate.jdbc.batch_size = 500

answered Nov 23 '19 at 13:08

Conrad

417
4
11

Spring Data JPA saveAll not doing batch insert

3 Answers3