Insert multiple rows in database using spring boot JPA

Question

I am new to spring. I am creating Rest API using spring boot with JPA. I want to add multiple rows to database MYSQL.

I have created controller where i am using save() method from repository to insert data into database. I want to add multiple rows to database but when i run the code only last value is added in database. If i try to create Userskill object for method each time it works fine but it is not feasible to create new object each time. This is portion of code of controller. Here, Userskill is model and table into which i want to insert a data.

    for(int i=0;i<listofskill.size();i++)
     {                           
         userskill.setUser_id(userid);           
         userskill.setSkill_id(skillRepo.findByName(listofskill.get(i)).getSkill_id());
         userskillRepo.save(userskill);          
     }

this code only add 1 row with last value. I want to add each value to the database.

You need to create a new object. The object represents the row in the db, as soon as it is saved, it is managed by JPA and all set methods will update the managed entity. Each row needs its own UsersSkill instance. — M. Deinum
– M. Deinum, Commented Aug 6, 2019 at 13:41
But what if i need to add 50 rows? It's not feasible to create 50 Userskill object. — Bhoomi Vaghasiya
– Bhoomi Vaghasiya, Commented Aug 6, 2019 at 14:05
As stated just create the objects. Why isn't it feasible, people all around the world,d are doing it like that. You are using JPA which means you have to work in the JPA way... If you don't want that don't use JPA. — M. Deinum
– M. Deinum, Commented Aug 6, 2019 at 14:08

user3153014 · Accepted Answer · 2020-10-30 06:08:06Z

2

You can create list of Userskill then add all the elements at once, check below code:

List<UserSkillObject> userskillList = new ArrayList<>();

for(int i=0;i<listofskill.size();i++){
   UserSkillObject userskill = new UserSkillObject();
   userskill.setUser_id(userid);           
   userskill.setSkill_id(skillRepo.findByName(listofskill.get(i)).getSkill_id());
   userskillList.add(userskill);
}
userskillRepo.saveAll(userskillList);

answered Oct 30, 2020 at 6:08

user3153014

3181 gold badge4 silver badges17 bronze badges

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

Comments

Fajar AM · Accepted Answer · 2019-08-09 09:03:39Z

1

try this

for(int i=0;i<listofskill.size();i++)
     {     
         UserSkillObject userskill  = new UserSkillObject ();
         userskill.setUserSkillId(newId);           
         userskill.setUser_id(userid);           
         userskill.setSkill_id(skillRepo.findByName(listofskill.get(i)).getSkill_id());
         userskillRepo.save(userskill);          
     }

answered Aug 9, 2019 at 9:03

Fajar AM

1164 bronze badges

2 Comments

eyoeldefare Over a year ago

This solves the problem but you're making multiple opens to the database. There should be one tripe to add all of the data.

user3153014 Over a year ago

@eyoeldefare you can add all the in the list at once using saveAll API, but for that you need to create list of Objects first.

Collectives™ on Stack Overflow

Insert multiple rows in database using spring boot JPA

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related