Spring Data JPA - for loop not saving entity

Question

I am trying to save multiple strings into one column into MySQL DB. Using Spring Data JPA with Hibernate.

I have my PersonserviceImpl as

    @Override
public void createnewPerson(AppPerson appPerson) {

    List<AppPersonproperty> personProperties = personpropertyRepository
            .findByPersonid(appPerson.getAppPersontype().getId());

        for (AppPersonproperty app : personProperties) {
            System.out.println(app.getPersonpropertyname());
            entity.setPersonpropertyname(app.getPersonpropertyname());
        }

    personRepository.save(entity);
}

Only the last value gets save from Person's previous names.

Sysout:

SpiderMan
Spidey

Expected value in the column:

SpiderManSpidey

Actual value in the column:

Spidey

What am I doing wrong here?

Jens Schauder · Accepted Answer · 2018-11-08 05:03:02Z

1

Why would JPA append Strings in a column when you are replacing them on the Java side?

If you want them appended in the column you need to append them on the Java side as well. Replacing

entity.setPersonpropertyname(app.getPersonpropertyname());

with

entity.setPersonpropertyname(entity.getPersonpropertyname() + app.getPersonpropertyname());

should do the trick.

answered Nov 8, 2018 at 5:03

Jens Schauder

82.6k35 gold badges199 silver badges379 bronze badges

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

1 Comment

Ajay Kumar Over a year ago

What a dumbo I am.! . Yes you are right Jens. Your trick is working.!!

Collectives™ on Stack Overflow

Spring Data JPA - for loop not saving entity

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related