Greetings,

I'm going to have to write a lot of modules that fetch a possibly large amount of objects using hibernate. Instead of using conventional methods such as limiting the number of fetched objects in each query (which would probably not be optimal because different objects may be with different sizes and also I would have to to many tests to find the limit for each query before OOME), I would like to somehow tell Hibernate that while fetching and building the returned collection to check the amount of memory that the collection occupies and if it is above a certain amount to stop or throw an exception or do anything recoverable. Does anyone have an idea how to to this?

Thanks.

I am wondering if you could do anything with either interceptors or events. you can examine an object for its collection size and throw an exception if you like. However, I have never used either events or interceptors and I can not tell you which method might be the best place to catch this.


Farzad-

Couldn't you iterate over all the results from a ScrollableResults instead of keeping all elements in memory?
You can create an iterator that wraps around a ScrollableResults and iterates over 'live' data.