You could, and actually most of the needed code is already in place due
to the feature of scrolling collection fetches.  The main problem there
is that it *only* works (in terms of what you are trying to achieve)
provided you know for certain that the results are ordered correctly
(namely, they must be ordered by the owning entity primarily such that
all possible rows for a given owner are contiguous within the result
set).  And what about polymorphic queries?

The cleanest solution is to fall back to subselect fetching in these
cases; which, of course, has its own implementation difficulties.

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Emmanuel Bernard
Sent: Tuesday, February 28, 2006 7:12 PM
To: Hibernate development
Subject: [Hibernate] setfirstResult() / setMaxResult() and collection
fetching

Wouldn't it be possible to implement that through a scrollable resultset

when a collection fetch is involved. This would limit the amount of data

in memory.



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel

Reply via email to