Hi,

I like to be able to use parameter with expression

like '%mysearchtext%'

For instance:

session.createQuery("From cat where name like '%:search%')
.setParameter("search", search);

How this is possible ?

Thank You

Hi,

Use criteria API

Criteria criteria = session.createCriteria(Cat.class);
criteria.add(Expression.like("search", cat.getSearch()+"%"));
List list = criteria.list();


Use you own combinations of search exploring criteria API.

Have fun:-)

hi,

try like this

session.createQuery("From cat where name like :search)
.setParameter("search", "%"+search+"%");