CODEWITHSUNDEEP
javahibernatejpa
DmiN
DmiN

Reputation: 786

Using hibernate named parameter twice

Assumed i have the following HQL

EntityManager.createQuery("SELECT a FROM a WHERE a.b = :par OR a.c = :par").setParameter("par", obj);

seems not to work. Does anybody have an idea how to solve this problem remain using only one parameter?

Upvotes: 21

Views: 28732

Answers (2)

Pramod H G
Pramod H G

Reputation: 1613

setParameter(String name,Object val)

Replaces all occurence of name, specified in the query.

Upvotes: 1

Dhivya
Dhivya

Reputation: 699

setParameter(String name,Object val)

This is used to bind a value to the named parameter. But a name can occur multiple times in a query that doesn't matter. So check once whether you have really data for that query.

check the documentation here

Some main text from that documentation

Named query parameters are tokens of the form :name in the query string. A value is bound to the integer parameter :foo by calling setParameter("foo", foo, Hibernate.INTEGER); for example. A name may appear multiple times in the query string.

If still u don't get the result then just try with using two names and set it

EntityManager.createQuery("SELECT a FROM a WHERE a.b = :par1 OR a.c = :par2").setParameter("par1", obj).setParameter("par2", obj);

Upvotes: 33

Related Questions