Hibernate query: positioned parameter and named parameter

Question

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?

Jeshurun · Accepted Answer · 2011-12-05 23:52:47Z

10

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();

answered Dec 5, 2011 at 23:52

Jeshurun

23.2k6 gold badges82 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

marcosbeirigo · Accepted Answer · 2021-06-02 18:02:26Z

0

I Don't think so, if you try it, hibernate you give you the following error:

org.hibernate.hql.ast.QuerySyntaxException: cannot define positional parameter after any named parameters have been defined

Why would you want to do that?

Edit: Jeshurun offers a much better solution. Please check his answer below.

edited Jun 2, 2021 at 18:02

answered Mar 20, 2010 at 11:04

marcosbeirigo

11.4k6 gold badges42 silver badges59 bronze badges

Collectives™ on Stack Overflow

Hibernate query: positioned parameter and named parameter

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related