Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

WHERE IN (?) ?

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

iHib

Post subject: WHERE IN (?) ?

Posted: Tue Feb 10, 2004 9:45 am

Newbie

Joined: Tue Feb 10, 2004 9:26 am
Posts: 12

Hi All.

I am running hibernate 1.2 with postgresql 7.2.4.
I would like to do a HQL query like the following passing a list or Array to the WHERE IN clause.

I would like to do something like this:

Code:

SELECT table
FROM table IN class com.sys.hib.Table
WHERE table.tableId IN (?)
new Object[] { idList },
new Type[] { Hibernate.? }
;

I'm sure this fairly straight forward I have just missed it.
Thanks in advance.
Ian...

Top

michael

Post subject:

Posted: Tue Feb 10, 2004 9:48 am

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

On 2.1.2:

session.createQuery("blabla where id in :something").setParameterList("something", list);

Don't know if this exists allready on 1.something and I'm not going to dig it up :)

Top

iHib

Post subject:

Posted: Tue Feb 10, 2004 12:14 pm

Newbie

Joined: Tue Feb 10, 2004 9:26 am
Posts: 12

Thank you very much, it works great on 1.2.
I had to change my DAO a bit bit it needed doing anyway.
I do plan on upgrading to latest stable soon.
Thanks again.
Ian...

Top

Page 1 of 1

[ 3 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