Dear All,
Im getting the above error when trying to execute the following HQL
Code:
hql= from IDLECustomers where trim(upper(clientCity))=? and statusId=? and callDate <?
Query q = sessionFactory.getCurrentSession().createQuery(hql);
q.setString(0, city.trim().toUpperCase());
q.setLong(1, statusId);
q.setDate(2, new Date());
Im using oracle10g as my db
clientCity is a String field which maps to varchar2 in db
statusId is a long field which maps to number in db
callDate is a java.sql.date field which maps the DATE in db
Do u guys have any idea about this issue?
Thanks
Pathum
Login
FAQ
Search