Storing a list of POJOs as JSON objects in Postgres

Question

I have a simple Java class which represents a real-life entity I have to store, such as this.

@Data
public class MappingValue {
    private String feature;
    private String value;
}

Now, I want to store several of these mappings as a list in a different entity. This entity is stored in a SQL table, and I want to store these mappings as a list of jsonb objects. I did something like this, but I can't seem to get it to work.

@Column(name = "specifications", columnDefinition = "jsonb")
private List<MappingValue> specifications;

Any ideas? Thanks in advance.

What does can't seem to get it to work mean?

123
– 123

2020-06-30 10:30:17 +00:00
Commented Jun 30, 2020 at 10:30 — 123
– 123, Commented Jun 30, 2020 at 10:30

Martin Scheuchenpflug · Accepted Answer · 2020-07-01 13:39:41Z

2

You use an JPA Attribute Converter for that. You implement such a Converter to Store a Complex type in one Column of the Db

Example: https://www.baeldung.com/jpa-attribute-converters

edited Jul 1, 2020 at 13:39

answered Jun 30, 2020 at 10:02

Martin Scheuchenpflug

1597 bronze badges

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

3 Comments

Anomitra Over a year ago

Yes, I'm aware of the separate table design. But I want this data in the same table, mostly because it's going to be a very unstructured set of keys and values and I don't necessarily want to force it into a separate table for the heck of it.

Martin Scheuchenpflug Over a year ago

Ok then maybe try to implement a Converter like mentioned here: stackoverflow.com/questions/43628222/…, This Converter could make a call to gson or smth like that

Anomitra Over a year ago

Thanks Martin, this helped. Can you add a bit more on your answer about Converters so that I can accept your answer?

Collectives™ on Stack Overflow

Storing a list of POJOs as JSON objects in Postgres

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related