How to map a JSON column with H2, JPA, and Hibernate

by

I just came across this problem working with the JSONB column type – the binary version of the JSON type, which doesn’t map to TEXT.

For future reference, you can define a custom type in H2 using CREATE DOMAIN, as follows:

CREATE domain IF NOT EXISTS jsonb AS other;

This seemed to work for me, and allowed me to successfully test my code against the entity.

Source: https://objectpartners.com/2015/05/26/grails-postgresql-9-4-and-jsonb/

More Related Contents:

  1. java.lang.ClassCastException: java.lang.String cannot be cast to
  2. How to solve the “failed to lazily initialize a collection of role” Hibernate exception
  3. How do I use annotations to define different types of relationships in Hibernate 4 and Spring?
  4. Bypass GeneratedValue in Hibernate (merge data not in db?)
  5. What is the proper way to re-attach detached objects in Hibernate?
  6. How does the FetchMode work in Spring Data JPA
  7. No Dialect mapping for JDBC type: 1111
  8. Spring Boot default H2 jdbc connection (and H2 console)
  9. Transaction marked as rollback only: How do I find the cause
  10. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  11. Hibernate could not fetch the SequenceInformation from the database
  12. Do you need a database transaction for reading data?
  13. Could not commit JPA transaction: Transaction marked as rollbackOnly
  14. Spring JpaRepository – Detach and Attach entity
  15. Rollback transaction after @Test
  16. How do I properly do a background thread when using Spring Data and Hibernate?
  17. Manually call Spring Annotation Validation
  18. Difference between save and saveAndFlush in Spring data jpa
  19. Getting a ‘No thread-bound request found’ error from spring in my web app
  20. Spring 4 + Hibernate 5 = org.springframework.orm.jpa.EntityManagerHolder cannot be cast to org.springframework.orm.hibernate5.SessionHolder
  21. compatibility of spring 4.0.0 with hibernate 4.30 [duplicate]
  22. Why HibernateTemplate isn’t recommended? [duplicate]
  23. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  24. Error creating bean with name ‘entityManagerFactory
  25. Hibernate: CRUD Generic DAO
  26. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  27. org.dbunit.dataset.NoSuchTableException: Did not find table ‘xxx’ in schema ‘null’
  28. Autowired Repository is Null in Custom Constraint Validator
  29. Registering a SQL function with JPA and Hibernate
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment