Hi, I just have a quick question and I'm hoping someone can give me a hand...

In my code I have a Set of IDs which correspond to the IDs for a specific object that I want to load and I was wondering if I could easily do this in one database call rather than iterating through the set of IDs and calling session.get on each one.

Right now my code looks like:
for(Long id : idSet) {
session.get(MyObject, id)
}

Basically what I'm looking for is similar to this SQL:

select * from MYTABLE where id in (... my id set ...)

Does anyone know how to do this in one call?

Criteria criteria = session.createCriteria(YourObjectClass.class);

criteria.add(Expression.equal("id", id???));

return criteria.list();

That will return a list with ID's where the id??? is equal to a given ID?

Then you can just iterate through your list which it returns?

Mr Jones, thanks a lot for your help.

What you are saying is exactly what I'm looking to do--to create one criteria or load/get statement which will take in a set of ids rather than a single id.

My only question, though, is about the syntax that you typed. What do the question marks represent where you type id???

If my set is named idSet then do I use
Expression.equal("id",idSet)
or am I supposed to use Expression.equal("id",idSet???)

The syntax doesn't make much sense to me.

Thanks again for your help...

Try hql:



Or criteria query:



If you find this useful, please award me a point!

Mikekonikoff, thanks for your help. "Restrictions.in" is exactly what I was looking for!

Dave