hi,

I am getting hibernate exception as
org.hibernate.QueryException: Not all named parameters have been set: [:int]

My code
String queryString ="SELECT history.serial Serial,history.timestamp,avg(regexp_replace(history.num_value,'[^0-9]','','g')::int * 10) NumValue,history.timestamp + interval '7 days' endtime "+
" FROM product_1 history"+
" WHERE history.serialnum = :serialnum"+
" AND history.index1 = :index1"+
" AND history.index2 = :index2"+
" AND history.checknum = :checkNum"+
" AND history.timestamp between :date1 and :date2 group by SerialNumber, timestamp, endtime order by timestamp asc";

SQLQuery query = sessionFactory.getCurrentSession().createSQLQuery(queryString);
query.addScalar("Serial");
query.addScalar("timestamp");
query.addScalar("NumValue");
query.setParameter("serialnum", serial);
query.setParameter("index1", index1);
query.setParameter("index2", index2);
query.setParameter("history.checknum ", keyNumMap.get("history.checknum "));
query.setParameter("date1", beginDate);
query.setParameter("date2", endDate);

Can anybody please tell me where am i goign wrong.
This works if i dont use avg function. I have num_value as character varying datatype in mapping file
thanks in advance

Please let me know if regex_replace is supported by hibernate
I am using postgre DB


Thanks

Looks like you have not set checknum instead you have set
history.checknum that too with space

query.setParameter("history.checknum ", keyNumMap.get("history.checknum "));