I just want to know how I can pass parameters to a LIKE comparison:

sessionHb.createQuery(from Person as p where p.name like '%<parameter>%')

Where <parameter> is I tried:

? and then writing .setString("a");

:param and then writing .setParameter("param", "a", Hibernate.STRING)

I know that I could pass as a normal concatenation:

String myString = "a";
sessionHb.createQuery(from Person as p where p.name like '%" + myString + "%')

I wanted to know if there is another way.

sessionHb.createQuery(from Person as p where p.name like :param)

then .setParameter("param", "%a%", Hibernate.STRING)

Or even shorter. :)



Best regards
Sven

Thank you very much! It was so easy, isn't it?