Hi,

I try to create a HQL query that simulate the SQL query:

SELECT id FROM table_name WHERE id IN (501,502)

For the HQL query I want to pass for the IN clause a parameter :

SELECT c.id FROM class_name as c WHERE c.id IN ?

I don't know how to set the parameter (which type the parameter) for the IN clause.
If I set it like a String I get from Oracle the error invalid number.

Does anybody has an idea how passing a parameter for an IN clause ?

Thanks,
Cristian.

I think you should use:


And bind the n parameters. (Note that Oracle only supports something like 1000 parameters.)

You should obviously know exactly how many parameters you're going to bind, and generate the string with the questionmarks yourself.

The problem is that I don't know before how many int parameters will be into the IN clause.

There isn't another solution at this ?

Well, if the int-params are not from a List, Set of Array, where are they from?

Should it be the result of a subquery, you should obviously use:

Have a look at Query.setParameterList().

This allows you to bind a List to a named parameter in a query.

Thanks a lot,

It works very well with the CSwinney solution.

It works also with the Varienaja solutions but the subselect is also dynamic.

I appreciate your help,
Cristian.