> >>> 2. No limit/offset or cursors.
> >>> In a word searches. If you are tring to search for
> >> something you display
> >>> a list of current values based on a selection criteria.
> What happens
> >>> when the list is 100,000 records. With current DB code you
> >> would declare
> >>> a cursor or use offset and limits and only retreive a bit
> at a time.
> >>>
> >>
> >> I would find this very useful as well.
> >>
> >
> > Duh. I think Oleg is working on this.
>
> I think there is a new J2EE bluprint pattern for this ? ...
>
> /
>
The blueprint
(http://java.sun.com/j2ee/blueprints/design_patterns/page_by_page_iterator/i
ndex.html) applies to client access of the result set. The problem is the
blueprint assumes that then entire result set of the query can fit into
server memory.
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
