I have a jsonb type column in postgres Table and need to compare the array of values. Trying to build Predicates using specification. Using like method of criteriaBuilder, it is giving couldnot extract result set error. In postgres table directly if I use @> able to get the result, can someone help to identify What is the criteriaBuilder method equivalent for @> for Postgres jsonb column instead of like?
Asked
Active
Viewed 185 times
0
-
You can't use posgres json types with JPA Criteria API – Simon Martinelli Jun 22 '21 at 06:41
-
Thanks. How to pass list of values in native query for @> argument – user3212324 Jun 22 '21 at 06:42
-
you can try referring to below solutions https://stackoverflow.com/questions/36041784/postgresql-compare-two-jsonb-objects – CodeLearnerSQL Jun 22 '21 at 13:21