I'm having trouble finding any documentation that shows how to build an
IN LIST clause without having to manually construct the SQL.
For example, here's a sample query I'm trying to get Hibernate to produce...
Code:
SELECT x FROM y WHERE z IN LIST ('A','B','C','D');
Essentially, I'm wanting to get a collection of 'x' objects based on a list of identifiers ('A','B','C','D').
The alternative I've been using is to make multiple SELECT calls...
Code:
SELECT x FROM y WHERE z = 'A';
SELECT x FROM y WHERE z = 'B';
SELECT x FROM y WHERE z = 'C';
SELECT x FROM y WHERE z = 'D';
... and stuff each individual result into a collection.
Login
FAQ
Search