Hi,

I've got a lucene index which based on a search can yield me a large number of IDs. These IDs are for objects which I've persisted thru hibernate. (The search results are limited to a hundred rows or so).

I then want to bring these objects back in thru Hibernate.
The simple approach seems to be just having a large number of ids in a WHERE ID IN (x1, x2, x3, ....).

I was just wondering whether this is the best way to do this, or whether there is a simpler / better way to query thru hibernate directly over a large number of primary keys?

Many thanks,

Dave

It looks like I can logically do this easily enough with Critiera:



Is there a practical limit on the number of values in the "in" clause here? (Im looking to support something like 100)

A quick unit test against HSQLDB shows that this works fine...