if you are using oracle database ,
you can try such kind of query
to get pages ordered based on some fields
select t.*
from (select ordered_e.*,rownum as rowno
from ( select e.*
from employee e
order by name ) ordered_e ) t
where t.rowno between :b1 and :b2
-----Original Message-----
From: David Graham [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 8:02 PM
To: Struts Users Mailing List
Subject: RE: [OT] Rendering Large ResultSet - Value List Handler Design
Pattern
--- Mark Galbreath <[EMAIL PROTECTED]> wrote:
> I send elements of the ResultSet to a String[] and pass it to the
> presentation tier.
The problem was that the ResultSet couldn't fit in memory so it had to be
displayed as it was read. Storing in a String[] is no better than using
DTOs in this situation.
David
>
> Mark
>
> -----Original Message-----
> From: David Graham [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 12, 2003 12:43 PM
>
> You can't store a ResultSet in an HttpSession because it's not
> Serializable.
> If you can't fit the result into memory, I would create an Iterator
> implementation that loops over a ResultSet and pass that to the
> presentation
> tier (Servlet or JSP) for rendering. That way you isolate the data
> retrieval details (ie. ResultSet) from the next layer.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
