HQL in expression

alcarrillo · **Joined:** Thu May 14, 2009 11:36 am **Posts:** 2

I am trying to use the in expression like in:

Code:

from DomesticCat cat where cat.name in ( 'Foo', 'Bar', 'Baz' )

But in my case I would need to pass 'Foo', 'Bar', 'Baz' as a parameter, so I have something like this:

Code:

from DomesticCat cat where cat.name in ( :names )

But I don't know how to set that parameter to the query. I have tried as follows:

Code:

myQuery.setParameter("names", new String[] {"Foo", "Bar", "Baz"})

But it didn't work. Any other idea?

Thanks a lot in advance for any help.

mmerder · **Posted:** Fri May 15, 2009 3:49 am

Here you'll find an example for that.

alcarrillo · **Joined:** Thu May 14, 2009 11:36 am **Posts:** 2

Tank you. I don't know why I didn't see the method setParameterList(...)

Thanks a lot :)