hi
i m new to Hibernate. i want to know whether i can pass List of objects to "in" operator in HQL or not. I think it works fine for strings.

Actually my HQL query is something like this:

"Select count(employees) from Employee employees where employees.category in ()"

i have a list named "categories" whose size changes dynamically and contains Objects of "Category" POZO.

Know i want to execute the above query, pasing this list to "in" operator.

And i Dont want to use "Expression.in", it consumes time.

Bye

Kamalpreet

Put following query in .hbm.xml file and run this as a named query

<query name="QueryName">
Select count(employees) from Employee employees where employees.category in ( :parameterList)"

<query>

in java class run it as

String parameterList = {} // This is array or category name

session.getNamedQuery("QueryName").setParameterList("parameterList",parameterList).executeUpdate();

Hope this helps

Sudhir

Pls rate if it helps

This is the pattern I use: