jpa named query : named bind variables for list

Question

if you have a namedquery with a list like :

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

is it possible to make the list to named bind variables so you set what you want with :

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

Any suggestions would be welcome

JB Nizet · Accepted Answer · 2012-12-26 13:52:48Z

11

Yes, it's possible. Just do it like 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"));

answered Dec 26, 2012 at 13:52

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Patrick M Over a year ago

Parenthesis not required? Other answer includes them – Found some details over at this answer

NPKR · Accepted Answer · 2012-12-26 13:54:43Z

2

Use this way

@NamedQuery(name="selection" , query=" SELECT x FROM Employee x WHERE x.name IN (:availableCollection)") 


namesCollection // conatains your Lsit of names

query.setParameterList('availableCollection', namesCollection);

answered Dec 26, 2012 at 13:54

NPKR

5,5165 gold badges35 silver badges48 bronze badges

Collectives™ on Stack Overflow

jpa named query : named bind variables for list

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related