Menu
There are two types of query parameters binding in the Hibernate Query. One is positioned parameter and another one is named parameter.
Can I use these two parameters in one Query?
783
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.
It's use question mark (?) to define a named parameter, and you have to set your parameter according to the position sequence. See example… String hql = "from Stock s where s. stockCode = ? and s.
uniqueResult() Convenience method to return a single instance that matches the query, or null if the query returns no results.
A positional parameter is set by its index in the clause. A named parameter is set by its name. When you are setting the values, you might have the values in an array, in which case the positional form could me more useful.
Sure you can, as long as you make sure all positional parameters precede any named parameters. Heres an example:
Query q =session.createQuery("select u from User u where u.location=? and u.id in (:user_ids)");
q.setParameter(0, location);
q.setParameterList("user_ids", userIds);
return q.list();
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
