How to save or update a lot of entities in a bulk/batch?

Question

I have an entity that follows this structure:

name: String(not null, unique),
value: Integer(not null)
id: Long(generated, not null, unique)

I have a list of entities(List<>), and I want to save them to a table or update if some were already in a table, but I need an effective way to do that with some bulk/batch insert/update. Now I've tried repository.saveAll and entityManager.merge, but I get the repeated value error, as it doesn't update the values that're already in a table. What should I do?

Refer to (this) [https://vladmihalcea.com/tag/batch/] article — Asgar, May 21 '22 at 13:37

score 0 · Answer 1 · answered Apr 24 '22 at 06:42

0

Please refer to this topic:

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

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

set the option spring.jpa.properties.hibernate.jdbc.batch_size to appropriate value you need (for example: 20).
use saveAll() method of your repo with the list of entities prepared for inserting.

answered Apr 24 '22 at 06:42

Mohamed Aymen Charrada

355
4
10

As I've already said, I cannot use saveAll(), because it throws an error, because it doesn't update the entity in the table and tries to insert a new one – ruslan agaev Apr 24 '22 at 10:22
Please verify you set this config: spring.jpa.properties.hibernate.jdbc.batch_size – Mohamed Aymen Charrada Apr 25 '22 at 08:58

How to save or update a lot of entities in a bulk/batch?

1 Answers1