Breaking News: Grepper is joining You.com. Read the official announcement!

jpa ms sql json data type

Helpless Horse answered on July 20, 2021 Popularity 9/10 Helpfulness 1/10

answer jpa ms sql json data type

jpa ms sql json data type

Comment

@Converter
public class JsonToMapConverter 
                    implements AttributeConverter<String, Map<String, Object>> 
{
    private static final Logger LOGGER = LoggerFactory.getLogger(JsonToMapConverter.class);

    @Override
    @SuppressWarnings("unchecked")
    public Map<String, Object> convertToDatabaseColumn(String attribute)
    {
        if (attribute == null) {
           return new HashMap<>();
        }
        try
        {
            ObjectMapper objectMapper = new ObjectMapper();
            return objectMapper.readValue(attribute, HashMap.class);
        }
        catch (IOException e) {
            LOGGER.error("Convert error while trying to convert string(JSON) to map data structure.");
        }
        return new HashMap<>();
    }

    @Override
    public String convertToEntityAttribute(Map<String, Object> dbData)
    {
        try
        {
            ObjectMapper objectMapper = new ObjectMapper();
            return objectMapper.writeValueAsString(dbData);
        }
        catch (JsonProcessingException e)
        {
            LOGGER.error("Could not convert map to json string.");
            return null;
        }
    }
}

Popularity 9/10 Helpfulness 1/10 Language javascript

Source: stackoverflow.com

Tags: javascript jpa json sql

Link to this answer
Share Copy Link

Contributed on Jul 20 2021

Helpless Horse

0 Answers Avg Quality 2/10

jpa ms sql json data type

Contents

More Related Answers

jpa ms sql json data type

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.