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

try something like


where vals is a Collection

Hi,

Thanks for ur help.

I am getting the following ClassCastException when i have the query just as the way you have mentioned. To be clear following is the code.

Collection featureList = new ArrayList();
featureList.add("GET_TAX");
featureList.add("GET_GEO_CODE");
Query query = HibernateUtil.getCurrentSession().getNamedQuery(
"Feature.findByFeatureNames");
query.setParameter("featureNames", featureList);
List outList = query.list();

Following is the query in my HBM file.

<query name="Feature.findByFeatureNames">
<![CDATA[SELECT a FROM FeatureHBImpl AS a WHERE a.featureCode in (:featureNames)]]>
</query>

I am getting the ClassCastException in this line.

List outList = query.list();

Please let me know if I am missing anything.

Thanks
Balaji

you need to use setParameterList, not setParameter

Hi Nathan/Kerstter,

Yep. That's what i missed.

I got it to work now. Thanks for ur help.

Balaji