Hibernate Community • View topic - How to bind a collection/array param in hql WHERE IN clause?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to bind a collection/array param in hql WHERE IN clause?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Neha

Post subject: How to bind a collection/array param in hql WHERE IN clause?

Posted: Wed Nov 22, 2006 7:44 pm

Newbie

Joined: Fri Nov 04, 2005 11:42 am
Posts: 13

Hi

I want to bind a collection or an array parameter in a hql statement for the "WHERE IN" clause. So for example, my hql looks something like:

Code:

select o from object o where o.id in :idList.

Can I do something like this? If not, is there any other way to do this besides adding all the ids to the hql string itself?

Thanks,
Neha.

Top

gopalsaha

Post subject:

Posted: Thu Nov 23, 2006 6:11 am

Regular

Joined: Tue Feb 24, 2004 11:42 am
Posts: 56

yes you can .
from Show show where 'fizard' in indices(show.acts)

Excerpts from 14.9. Expressions in hobernate documentation

Hope this helps

Please dn't forget to rate

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum