How to map a map JSON column to Java Object with JPA

by

You can use a JPA converter to map your Entity to the database.
Just add an annotation similar to this one to your params field:

@Convert(converter = JpaConverterJson.class)

and then create the class in a similar way (this converts a generic Object, you may want to specialize it):

@Converter(autoApply = true)
public class JpaConverterJson implements AttributeConverter<Object, String> {

  private final static ObjectMapper objectMapper = new ObjectMapper();

  @Override
  public String convertToDatabaseColumn(Object meta) {
    try {
      return objectMapper.writeValueAsString(meta);
    } catch (JsonProcessingException ex) {
      return null;
      // or throw an error
    }
  }

  @Override
  public Object convertToEntityAttribute(String dbData) {
    try {
      return objectMapper.readValue(dbData, Object.class);
    } catch (IOException ex) {
      // logger.error("Unexpected IOEx decoding json from database: " + dbData);
      return null;
    }
  }

}

That’s it: you can use this class to serialize any object to json in the table.

More Related Contents:

  1. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  2. Hibernate Annotations – Which is better, field or property access?
  3. How to map calculated properties with JPA and Hibernate
  4. Mapping PostgreSQL JSON column to a Hibernate entity property
  5. When and why JPA entities should implement the Serializable interface?
  6. Spring Data JPA – ZonedDateTime format for json serialization
  7. JPQL Create new Object In Select Statement – avoid or embrace?
  8. How to annotate MYSQL autoincrement field with JPA annotations
  9. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  10. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  11. Storing a Map using JPA
  12. JPA/Hibernate Native Queries do not recognize Parameters
  13. How to persist a property of type List in JPA?
  14. I found JPA, or alike, don’t encourage DAO pattern
  15. Getting Database connection in pure JPA setup
  16. Hibernate – @ElementCollection – Strange delete/insert behavior
  17. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  18. How to clone a JPA entity
  19. Is there such thing CASE expression in JPQL?
  20. JPA Criteria builder IN clause query
  21. Is it possible to dynamically define column names in Hibernate / JPA?
  22. @Basic(optional = false) vs @Column(nullable = false) in JPA
  23. No operator matches the given name and argument type(s). You might need to add explicit type casts. — Netbeans, Postgresql 8.4 and Glassfish
  24. Batch inserts with JPA/EJB3
  25. Hibernate triggering constraint violations using orphanRemoval
  26. What is Persistence Context?
  27. How to create join table with JPA annotations?
  28. Change Table Name of an Entity on runtime? [duplicate]
  29. How to map one class to different tables using hibernate/jpa annotations
  30. How to use Postgres JSONB datatype with JPA?

Leave a Comment