Hibernate named query parameter

Question

I am having problem with named query parameter. My query is as follow:

<sql-query name="getCustomer">
<![CDATA[
     select * from customer where customerId=:custId and billId in ( :billIdList )
]]>
</sql-query>

I am setting all parameters, but having problem in :billIdList whenever I am setting this parameter I am getting a Empty list of customers. My :billIdList is in the string form e.g: 5,6,7,9. There is data in DB also with above values. It works fine when I am writing query in program it self.

Please help me.

ChssPly76 · Accepted Answer · 2009-10-01 16:17:05Z

1

For parameters with more than one value you need to use a setParameterList() method of Hibernate's Query interface:

query.setParameterList("billIdList", new int[] {5,6,7,9});

answered Oct 1, 2009 at 16:17

ChssPly76

101k25 gold badges210 silver badges196 bronze badges

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

Collectives™ on Stack Overflow

Hibernate named query parameter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related