how to insert multiple entries to postgres using spring, JPARepository

Question

Like I have an ArrayList, Then I call my repo from service, somewhat like

userRepository.insertUsers(userArrayList);

and here i have my repository

@Repository
public interface UserRepository extends JpaRepository<User, Long> {

@Transactional
@Modifying()
@Query("INSERT INTO usermaster ..........")
    public int insertUsers(@Param("userArrayList") List<User> userArrayList);

}

all I need is a query to bulk insert this ArrayList above, I couldn't find an answer for this. Thanks in advance.

have you tried with the default method save? like this: userRepository.save(userArrayList); — David Pérez Cabrera
– David Pérez Cabrera, Commented Jul 25, 2017 at 9:31
You don't need a @Repository annotation when you implement on of Spring Datas repository interfaces. — Jens Schauder
– Jens Schauder, Commented Jan 30, 2018 at 5:54

bvrakvs · Accepted Answer · 2018-06-28 07:33:47Z

3

You do not need custom method, JpaRepository has save method which accepts list of your entity, this will be enough

userRepository.save(userArrayList);

edited Jun 28, 2018 at 7:33

bvrakvs

14.7k4 gold badges55 silver badges96 bronze badges

answered Jul 25, 2017 at 9:32

Amer Qarabsa

6,6343 gold badges25 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to insert multiple entries to postgres using spring, JPARepository

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related