hql query formation

Posted by sarah on Stack Overflow See other posts from Stack Overflow or by sarah
Published on 2010-06-09T06:57:26Z Indexed on 2010/06/09 7:02 UTC
Read the original article Hit count: 220

Filed under:
|

Hi

I want to construt a hql query like

select PLAN_ID from "GPIL_DB"."ROUTE_PLAN" where ASSIGNED_TO 
      in ('prav','sheet') and END_DATE > todays date

I am doing in this way but getting an error in setting parameters

s=('a','b');
Query q = getSession().createQuery("select planId from RoutePlan where assignedTo in REG ");
if(selUsers != null) {
   q.setParameter("REG", s);
}

where i am doing wrong?

© Stack Overflow or respective owner

Related posts about java

Related posts about hibernate