Map Json string in Mysql's json type column vai hibernate

Question

I am looking to create json data type column in MySQL via hibernate during startup. I don't want any kind of transformation while saving or fetching data. I just want to store json string ( rather than an object) into json column.
How could I achieve via hibernate.
Any idea or hint, please ?

• Akina: MySQL will reconstruct your JSON value (the value retrieved may differ from the value saved - in components ordering) if you'll use JSON datatype column. Is it safe for you? If not then use VARCHAR/TEXT datatype instead.
• Tarun: @Akina At max I assume, MySQL would reorder the keys of JSON and nothing much. I am okay with it. The problem lies in that Hibernate does not identify "JSON" type.
• Akina: At max I assume, MySQL would reorder the keys of JSON and nothing much. That's true. For some OPs the physical order makes sense somewhy...
• Tarun: @Akina Do you know how could I introduce JSON type in hibernate ?
• Akina: See, for example, this.

Answer 1

I used the following xml property ("sql-type") to create json data type: E.g:

 <property name="template">
 <column name="template" sql-type="json"/>
 </property>

This was enough for me as I am not looking for transformation between json and object. For transformation, one can create converter.

Thanks to @Akina for helping me with useful links and suggestion.