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.

Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.