How to use IN Clause in HQL

[Murali Charan]

Hi All,

I am new to hibernate. My project already has hibernate implementation. I have introduce a new query which should use a IN clause.

For E.g.,

SELECT * FROM FEATURE WHERE FEATURE_NAME IN ('TAX','GEO_CODE');

I will be getting the values in the IN clause in a collection in my code.
How should i pass the value to the HQL query?
How will the HQL query look like?

Thanks,
Balaji

[Arun Kumarr]

Query query = getSession().createQuery("Select ioObject from IoObject as ioObject where ioObject.subTotalVariable.varId in (:varList)")
         .setParameterList("varList",variableList);

Here subTotalVariable is an Object.

lest you can use something like this,

 Query query = getSession().createQuery("Select ioObject from IoObject as ioObject where ioObject.Id in (:IdList)")
         .setParameterList("IdList",IOObjectIdList);

[Ram Subramanian]

It works great. Good work dude.