Hibernate could not locate named parameter even if it exist

java hibernate hql named-parameters
user962206 picture user962206 · Jan 24, 2013 · Viewed 43.2k times · Source

Hibernate Keeps detecting 

org.hibernate.QueryParameterException: could not locate named parameter [name]

even though it exist. here's my hql

Query query = sess().createQuery("from UserProfile where firstName LIKE '%:name%'").setParameter("name", name);

Why does hibernate keeps throwing that exception? even though the parameter exist?

Answer

Stanislav Bashkyrtsev picture Stanislav Bashkyrtsev · Jan 24, 2013

Should be like this:

Query query = sess().createQuery("from UserProfile where firstName LIKE :name")
                    .setParameter("name", "%"+name+"%");

In your case ':name' is actual string Hibernate will search for. If you need to have a real named parameter, you need to have just :name.

Thus % should be passed as a value of :name and Hibernate will substitute :name with actual value.

Note, that if your value contains % and you want it to be an actual letter instead of wildcard, you'll have to escape it, here is an example of escaper-class.

Related questions

How do you do a limit query in JPQL or HQL?

In Hibernate 3, is there a way to do the equivalent of the following MySQL limit in HQL? select * from a_table order by a_table_column desc limit 0, 20; I don't want to use setMaxResults if possible. This definitely was possible …

Read More
What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate

Please help me understand where to use a regular JOIN and where a JOIN FETCH. For example, if we have these two queries FROM Employee emp JOIN emp.department dep and FROM Employee emp JOIN FETCH emp.department dep Is …

Read More
ORDER BY using Criteria API

When I write a HQL query Query q = session.createQuery("SELECT cat from Cat as cat ORDER BY cat.mother.kind.value"); return q.list(); Everything is fine. However, when I write a Criteria Criteria c = session.createCriteria(Cat.class); …

Read More