Fetching children entities IDS (rather than whole entities)when fetching collections?

[yannick1976]

Hello all !

Basically my problem is the following :
We have some objects for which we use the second level cache.
When we retrieve a collection of these objects, what hibernate should do is fetch ids, and then get elements from the cache.
Instead, it fetches all objects at once.

This is quite a problem if these objects are big and many entities have collections of them...

Seems that what we would need would be a new fetch mode (maybe lazy mode) where we would first get ids and then get the entities one by one.

Anyone knows how to do this, or maybe a JIRA about the issue ?

Thanks in advance

Yannick

[bkn]

You can do that using an OpenSessionInViewFilter.

[yannick1976]

Mmh, well, I don't see a link. Think you read too fast

[karldmoore]

You have to be careful when dealing with potentially large sets of data. OSIV is useful but can help cause problems if not used properly. You might want to have a look at the various options hibernate has for pagination and batched fetching, they might be of use.

[yannick1976]

Well, maybe I was unclear in my post, but again I don't think OSIV has anything to do with it.