JPA: Bulk Insert records into element collection

Question

Is there a way to bulk insert values into a List element collection?

This is a sample of the entity:

    public Class File{
     private String name;
     @ElementCollection
     @CollectionTable(name="file_tags")
     private List<String> tags = new ArrayList<>();
      .....
    }

I Need to add a list of tags to a large number of files (hundred of thousands)... That's why I am looking for a way to do it in a bulk insert... I searched with no result till now.

Note that I am using eclipselink as JPA provider.

Please take note of the hack provided in- [bulk insertion example](https://stackoverflow.com/questions/16580535/bulk-insertion-of-collectiontable-elements-in-hibernate-jpa) — Vijay, May 18 '20 at 12:39

score 3 · Accepted Answer · answered May 18 '20 at 12:01

you have to enable batch writing by adding these 2 properties inside your persistence.xml

 <!-- Enable batch writing -->
 <property name="eclipselink.jdbc.batch-writing" value="JDBC"/>
 <!-- Batch size -->
 <property name="eclipselink.jdbc.batch-writing.size" value="100"/>

score 0 · Answer 2 · answered May 18 '20 at 11:59

0

Is it with reference to List that you are looking for the bulk insert of JPA? For eclipse link JPA you can use the batch insert for bulk insertion, in case you have sequences it might take time.

answered May 18 '20 at 11:59

tm_user

3
3

JPA: Bulk Insert records into element collection

2 Answers2