How to store json object in a column of mysql using spring boot/java

Question

Requirement is like that a json object is send from postman and i need to receive it on a restcontroller and save that whole json object as it is to the mysql database Table Column(in one/single column) using spring boot.

{
    "name" : "abc",
    "address : "xyz"
}

assume the above json object is send from postman to a spring boot restcontroller. How can i save that json object in a column of a table .

vb.stack · Accepted Answer · 2021-01-16 13:00:45Z

6

MySQL supports JSON column types. https://dev.mysql.com/doc/refman/8.0/en/json.html

So, assuming you will be using json column type for your requirement, you can follow below articles. I was able to do this for postgres as well, works very well for me, the instructions are pretty straightforward.

https://vladmihalcea.com/how-to-map-json-objects-using-generic-hibernate-types/ https://vladmihalcea.com/java-map-json-jpa-hibernate/

answered Jan 16, 2021 at 13:00

vb.stack

4113 silver badges10 bronze badges

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

2 Comments

Surjeet Singh Rathore Over a year ago

Helpful .. Thanks .

A.Casanova Over a year ago

You need an external dependency for this approach

David Dionis · Accepted Answer · 2021-01-16 12:48:13Z

1

There's no way. You can save it parsing the JSON to String ( Ex: JSON.stringify() ) and when you query the info , parse the string to JSON (Ex: JSON.parse() )

JSON.stringify: https://developer.mozilla.org/es/docs/Web/JavaScript/Referencia/Objetos_globales/JSON/stringify

JSON.parse: https://developer.mozilla.org/es/docs/Web/JavaScript/Referencia/Objetos_globales/JSON/parse

answered Jan 16, 2021 at 12:48

David Dionis

965 bronze badges

Collectives™ on Stack Overflow

How to store json object in a column of mysql using spring boot/java

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related