Mapping MySQL JSON column to hibernate value type

Question

What is the best practice for working with JSON column within Java code? Specifically I am interested in being able to save & query JSON columns in a MySQL DB using hibernate..

@Entity
public class MyEntity {

    private String myField; // this field is a json column

    public MyEntity() {
    }
}

If you're using the JSR-353 javax.json classes, then there is one way to automate the conversion to and from strings by just adding this dependency to your project mvnrepository.com/artifact/com.mopano/… Otherwise, you'll just have to use manual conversion or try and hope that a JPA AttributeConverter works. — coladict
– coladict, Commented Mar 28, 2018 at 7:02

Vlad Mihalcea · Accepted Answer · 2020-02-05 13:22:55Z

3

There is a good library to deal with JSON types in Hibernate. It's called Hibernate Types, and you can scroll down to the MySQL section to get the right example.

And some samples of usage MySQL's JSON API inside query:

How to search JSON data in MySQL?

edited Feb 5, 2020 at 13:22

Vlad Mihalcea

156k85 gold badges599 silver badges984 bronze badges

answered Mar 30, 2018 at 18:17

Alex Chernyshev

1,74510 silver badges13 bronze badges

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

2 Comments

Daniel Patrick Over a year ago

I get exceptions when using this library with values that are set to null or objects that are nested more than one layer deep. Anyone have any ideas on that?

Alex Chernyshev Over a year ago

@DanielPatrick , this library is based on common Jackson library, so at least issue with null could be solved by proper Jackson mapper configuration fasterxml.github.io/jackson-annotations/javadoc/2.0.0/com/… . Will be good to see an error trace actually to be more specific.

Collectives™ on Stack Overflow

Mapping MySQL JSON column to hibernate value type

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related