Querying by value in JSONB field in h2/postgresql
I have following json field in entity:
{"uuid", "uuid2"}
and I want to use @Query to find an entity which contains given uuid in this field. I have found a solution for postgresql (which we are using), but when I try to test it using h2 I get Function JSONB_EXISTS not found exception.
Is it possible to make it work with both postgresql and h2 using same query?
How I am creating a query (this works fine for postgresql, but not for h2):
@Query(
nativeQuery = true,
value = "SELECT * FROM...