Jpa named query: named bind variables for list

Question

if you have namedquery with a list like:

@NamedQuery(name="selection" , query=" SELECT x FROM Employee x WHERE x.name IN ('Jack', 'Jill')") 

Is it possible to list a list with bind variable names so that you set what you want:

 q.setParameter( ....... ); 

Any suggestions are welcome.

Answer 1

Yes it is possible. Just do it as for any other parameter:

 @NamedQuery(name="selection" , query=" SELECT x FROM Employee x WHERE x.name IN :names") q.setParameter("names", Arrays.asList("Jack", "Jill")); 

Answer 2

Use this method

 @NamedQuery(name="selection" , query=" SELECT x FROM Employee x WHERE x.name IN (:availableCollection)") namesCollection // conatains your Lsit of names query.setParameterList('availableCollection', namesCollection);