I have a JSONArray
field in the object:
@Column(name = "_history", columnDefinition = "JSON") @Convert(converter = JSONArrayConverter.class) private JSONArray history;
This is the code for JSONArrayConverter
:
@JsonSerialize @Converter(autoApply = true) public class JSONArrayConverter implements AttributeConverter<JSONArray, String> { public static final Logger LOGGER = LoggerFactory.getLogger(JSONObjectConverter.class); @Override public String convertToDatabaseColumn(JSONArray array) { LOGGER.debug(array.toString()); if (array == null) return new JSONArray().toString(); String data = null; try { data = array.toString(); } catch (final Exception e) { LOGGER.error("JSON writing error", e); } return data; } @Override public JSONArray convertToEntityAttribute(String data) { if (_EMPTY.equals(data) || data == null || "[]".equals(data)) return new JSONArray(); JSONArray array = null; try { array = new JSONArray(data); } catch (final Exception e) { LOGGER.error("JSON reading error", e); } return array; } }
The problem is that when requesting the object from the MySQL database (history is a JSON column and has data), Spring Boot returns it as empty:
"history": {}
Finally, I solved the problem.
First, add the above repository to
pom.xml
. Then change the code to the following:Then everything works fine.