JDBCtemplate and mysql json column support – how to query json value and write json value
Is there a way to query json column value from a column with datatype JSON in mysql through JDBCtemplate such that the value is returned as JSON . Similarly how to insert value of the json through jdbc template insert query.
All answers so far point out to read as string and then convert to JSON and write as string. If I use this how can I use the capabilities of the json datatype.