Hi
I think the easiest way is, in fact, to use jdbc to process the json directly from the BD. In fact, I ask, do you have an important need to save the information as Json? Wouldn't it be convenient to store it directly in a secondary table?
https://dev.mysql.com/doc/refman/8.0/en/json.html