Spring Data JPA: How to bulk insert data

Discussing 3 Options to bulk insert data in RDBMS

Suraj Mishra

·

Follow

Published in

Javarevisited

·

5 min read

·

May 1, 2023

--

Share

Originally Published in https://asyncq.com/

Introduction

• As a Software engineer who works primarily as a backend engineer or full-stack engineer, we often come across use cases where inserting data as bulk into the database is paramount.
• Some of the use cases will be like backfilling newly modified tables with old table data, populating secondary database tables with the primary database, or even taking back up of actual data, etc.
• In this article, we will discuss how we can insert data in bulk into the database using Spring Data JPA.

Entity

• For this example, we are using the Accounts table as shown below. This table gets a unique primary key Id from the accounts_seq generator.

@Entity
@Table(name="ACCOUNTS")
public class Account {
    @Id @GeneratedValue(strategy= GenerationType.SEQUENCE, generator = "accounts_seq")
    @SequenceGenerator(name = "accounts_seq", sequenceName = "accounts_seq", allocationSize = 1)
    @Column(name = "user_id")
    private int userId;
    private String username;
    private String password;
    private String email;
    private Timestamp createdOn;
    private Timestamp…