java - JPA CriteriaBuilder SELECT two Columns WHERE values IN Collection of Tuples -

java - JPA CriteriaBuilder SELECT two Columns WHERE values IN Collection of Tuples -

- January 15, 2015

i have question jpa criteriabuilder.

i have table 2 foreign keys a_id , b_id. want select records pair of (a_id, b_id) in set of tuples. possible build query criteriabuilder?

in oracle database followed query work:

select a.id table_name (a.a_id, a.b_id) in ((123, 21), (423, 32));

but have difficulty build clause criteriabuilder. in expression work single value? or maybe possible same thing subquery?

Comments