Hibernate HQL like query using named parameters
Using the LIKE condition with a “%” sign for pattern matching in a HQL query with named parameters required some tweaking.
This did not work:
String query = "from user u where u.name like %:name%"
getHibernateTemplate().findByNamedParam(query, "name", str);
It resulted in a org.hibernate.QueryException: unexpected char: ‘%’ error.
Next I tried using single quotes:
String query = "from user u where u.name [...]