SpringBoot map Java entity to Json column in database

Question

Need help in mapping entity attribute of Spring to json column in Postgres DB using JPA hibernate. We have a column in db whose type is JSON but cant find its corresponding mapping in spring.

Tried with this-

 @Column(name = "tags", columnDefinition = "jsonb")
 @JsonProperty("tags")
 private Map<String,Object> tags = new HashMap<>();

But with this, we getting error while creating db table Any suggestions regarding this? Thanks. Any help is appreciated.

GnanaJeyam · Accepted Answer · 2022-05-19 06:30:44Z

4

There is no out of box support for this. But you can use vladmihalcea library.

Gradle Dependency:

implementation 'com.vladmihalcea:hibernate-types-52:2.16.2'

Your Entity:

import com.vladmihalcea.hibernate.type.json.JsonType;
import org.hibernate.annotations.Type;
import org.hibernate.annotations.TypeDef;
import org.hibernate.annotations.TypeDefs;

import javax.persistence.Column;
import javax.persistence.Entity;

@Entity
@TypeDefs({
    @TypeDef(name = "json", typeClass = JsonType.class)
})
class YourPojo {
    
    @Type(type = "json")
    @Column(name = "tags", columnDefinition = "json")
    private Map<String,Object> tags = new HashMap<>();
}

answered May 19, 2022 at 6:30

GnanaJeyam

3,19022 silver badges32 bronze badges

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

3 Comments

Sai Over a year ago

It works with this.Thanks! But the Annotations are now deprecated for this hibernate version

GnanaJeyam Over a year ago

Cool. If it works you can upvote that will help others.

AnasSafi Over a year ago

not worked with jpa 6, TypeDefs removed

Collectives™ on Stack Overflow

SpringBoot map Java entity to Json column in database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related