hello,

I want to run this kind of query:

from X x where x.y in (?)

I found examples of this using session.createQuery() but none using session.find() directly.
Is it possible at all? If it is, what should I specify as the type of the parameter?

I am using Hibernate 2.0.3.

best regards,
erik

hello erik,
IN is supported by hql. Take a look in documentaion at chaper 10 HQL. There are also some examples...

I didn't tried that, but IMO think this should work:

List moreCats = sess.find(
"from Cat as cat where " +
cat.id in ( ?, ?)",
new Object[] { id1, id2 },
new Type[] { Hibernate.LONG, Hibernate.LONG }
);

hi,

sorry, I was a bit unclear in my original question - yes I know you can do like your example.

But I was thinking of something like this:


Because I didn't want to hardcode the number of statuses that are looked for.

I know you can do this like this:


So I was wondering if this is somehow possible without creating a Query object.

But I think it is not because now I looked at the debug log from the Query it seems that it creates an HQL statement using three parameters inside IN clause.

best regards,
erik