Hi,
I am looking to use IN clause in my HQL. I referred some forums and couldnt get an optimal idea for this.
One approach i tried is to set the parameter of HQL as shown below:
My HQL: SELECT prd FROM ProductORM AS prd WHERE prd.productID in (:selPrdIDs)
Java code: hqlQuery.setParameterList("selPrdIDs", prdIdList); //prdIdList is List<Integer>
But this resulted in SQLGrammarException: could not execute query ; SQLException: Invalid parameter binding(s)
Please help to implement IN clause in HQL...
Thanks,
Ganesh