Hi All,

I'm using below code for getting the record for matching 'TicketId'

Criteria crit = HibernateUtil.getSessionFactory()
.getCurrentSession().createCriteria(HelpManager.class);
crit.add(Restrictions.eq(mainCriteria, new Long(ticketId)));
List result = crit.list();

This is working fine(example, if I'm passing 'ticketId' 70 and it is retrieving the record for 70).

Now I'd like to get the records which are starting with 7(so I'm trying with 7% in like query but it is not working). It is throwing error. I'm trying like query in below way:

Criteria crit = HibernateUtil.getSessionFactory()
.getCurrentSession().createCriteria(HelpManager.class);
crit.add(Restrictions.like(mainCriteria, criteria1));
List result = crit.list();

The 'criteria1' is having value '7%' and 'mainCriteria' is having 'TicketId'.

Please let me know, in case the data type is 'String' then it is working fine.

Thanks in advance.

Regards,
Sharath Karnati.

tsql, not hql, 'like' only works with strings. for this to work you'll need to convert the long to a string.
I'm brand new to nhibernate, so I'm not sure how (if possible) to generate the sql