manipulate JSON array in Spring Hibernate

Question

I'm trying to store an JSON Array in MySQL with Spring and Hibernate.

The application gets the likes from the users and stores the id of a user in a JSON Array, for example

[1,2,3,4,5,6]

in a column name likeswith type text (MySQL)

¿How can I put a new id in the array? I mean, get the JSON form database and insert the id and count the number of elements.

Zeus · Accepted Answer · 2014-12-30 17:15:56Z

2

I'd use transient variables as a solution for this problem. I don't think there is a better solution for this. You may also try hibernate interceptors for this as a solution.

@Table
@Entity(name='Likes')
public class LikesEntity implements Serializable {

    @Transient
    private List<String> userIds;
    @Column
    private String likes;
    @Column
    private String count;

     //getter and setters for the like and count
    ...
    public void addUserId(String id){
        this.userIds.add(userIds);
        this.likes = convertToJsonArray(userIds); // use GSON or Jackson or any other library that can help you convert array to JSON string
        this.count = this.userIds.size();
    } 


}

within your service layer do the following

 @Transactional(lockmode = LockMode.READ){
   LikesEntity le = sess.get(LikesEntity.class,234);
   le.addUserId("userPk");
   session.saveOrUpdate(le);
 }

edited Dec 30, 2014 at 17:15

answered Dec 30, 2014 at 16:39

Zeus

6,6347 gold badges60 silver badges94 bronze badges

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

Collectives™ on Stack Overflow

manipulate JSON array in Spring Hibernate

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