How to save multiple String element from List<String> into a db using JPA?

Question

I tried so far the below code:

Session session = null;
Query query1 = null;
Query query2 = null;

String[] parts = userId.split("=");
userId = parts[1];
parts = userId.split(" ");
userId = parts[0];
int intIdUser = Integer.parseInt(userId);

try {
    session = getSession();

    UserCountry userCountry = new UserCountry();
    UserLanguage userLanguage = new UserLanguage();

    for (String s : user_country) {
        userCountry.setUserId(intIdUser);
        userCountry.setCountryId(Integer.parseInt(s));

        session.getTransaction().begin();
        session.persist(userCountry);
        session.getTransaction().commit();
    }

    for (String s : user_language) {
        userLanguage.setUserId(intIdUser);
        userLanguage.setLanguageId(Integer.parseInt(s));

        session.getTransaction().begin();
        session.persist(userLanguage);
        session.getTransaction().commit();
    }
}

catch(Exception e) {
    logger.error("Exception while fetching for countryId: "+userId, e);
    throw new PlRuntimeException(e.getMessage());
    }
finally {
    if(session !=null)
        session.close();
}

But the for (String s : user_country) and for (String s : user_language) loops are saving just first element on the list user_country and user_language.

How to make it save the other elements on the list?

Thanks for advice.

Suresh Atta · Accepted Answer · 2014-07-02 14:32:50Z

1

You are continuously updating the same object.

You just need to create the UserCountry and UserLanguage inside the loop. As of now you are creating outside the loop. Just move them inside the loops.

For ex :

for (String s : user_country) {
        UserCountry userCountry = new UserCountry();
        userCountry.setUserId(intIdUser);
        userCountry.setCountryId(Integer.parseInt(s));

        session.getTransaction().begin();
        session.persist(userCountry);
        session.getTransaction().commit();
    }

answered Jul 2, 2014 at 14:32

Suresh Atta

122k38 gold badges206 silver badges315 bronze badges

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

6 Comments

user3798114 Over a year ago

This one helped! Thanks.

user3798114 Over a year ago

@SURESH ATA: Can you please provide a solution to a DELETE row solution using JPA?

ROROROOROROR Over a year ago

it's weired, in his question, he said loops are saving just first element on the list user_country and user_language. but it should be last one if he repeats updating the same persisitent instance, isn't it?

Suresh Atta Over a year ago

@ROROROOROROR Since all are same. he confused :)

user3798114 Over a year ago

Yup :) Any solution os deleting rows?

|

Collectives™ on Stack Overflow

How to save multiple String element from List<String> into a db using JPA?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related