Here is the from clause from Hibernate documentation:
from DomesticCat cat where cat.name in ( 'Foo', 'Bar', 'Baz' )

I am trying to pass parameter (String array) instead of literals: 'Foo', 'Bar', 'Baz', like this: new String[]{"transfer1", "transfer2"}


My query looks like this:
select transfer from TransferImpl as transfer
where transfer.name in (?)

I am getting empty collection in return.
Where is the problem? Is query OK?

Thanks!

Have you tried a list instead of array?

I did. Still no solution. Thank you.

Do you use Query.setParameterList(String name, Object[] vals)? What is your actual query if you use a jdbc logger such as p6spy?



Farzad-