What would be nice if i could execute an sql statement which would give me a sub set of the results as contolled by a start and end position i specify e.g.
Select code, desc from products where ROW_NUM >= 1 and ROW_NUM <= 10
From: "Mark Galbreath" <[EMAIL PROTECTED]>
Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
To: "'Struts Users Mailing List'" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
Subject: RE: [OT] Rendering Large ResultSet - Value List Handler Design Pattern
Date: Tue, 12 Aug 2003 12:52:13 -0400
I send elements of the ResultSet to a String[] and pass it to the presentation tier.
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]
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
