RE: [OT] Rendering Large ResultSet - Value List Handler Design Pa ttern

["David G. Friedman" <hu...@ix.netcom.com>]

Ibatis?  Bah humbug.  I just jumped for joy because I got Hibernate (v2) working for a simple Struts login application I made (step 1 of many in my project).  No, don't ask to see my facade (not made yet) or my action (looks ugly without a facade).

Regards,
David

-------Original Message-------
From: Jerry Jalenak <Je...@LABONE.com>
Sent: 08/12/03 01:09 PM
To: 'Struts Users Mailing List' <st...@jakarta.apache.org>
Subject: RE: [OT] Rendering Large ResultSet - Value List Handler Design Pa ttern

> 
> Take a look at iBatis (www.ibatis.com).  It supports lazy loading of data,
caching of results, and paging for large result sets.  Might be of some
use
(it is for me, anyway).

Jerry Jalenak
Team Lead, Web Publishing
LabOne, Inc.
10101 Renner Blvd.
Lenexa, KS  66219
(913) 577-1496

jerry.jalenak@labone.com


-----Original Message-----
From: Pat Quinn [mailto:pat_quinn2009@hotmail.com]
Sent: Tuesday, August 12, 2003 12:02 PM
To: struts-user@jakarta.apache.org
Subject: RE: [OT] Rendering Large ResultSet - Value List Handler Design
Pattern


where do you keep the initial resultset? Or do you execute the query each 
time the user requests to page?

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" <ma...@qat.com>
>Reply-To: "Struts Users Mailing List" <st...@jakarta.apache.org>
>To: "'Struts Users Mailing List'" 
><st...@apache.org>
>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:grahamdavid1980@yahoo.com]
>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: struts-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: struts-user-help@jakarta.apache.org
>

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org


This transmission (and any information attached to it) may be confidential 
and is intended solely for the use of the individual or entity to which it 
is addressed. If you are not the intended recipient or the person
responsible for delivering the transmission to the intended recipient, be advised
that you have received this transmission in error and that any use,
dissemination, forwarding, printing, or copying of this information is strictly
prohibited. If you have received this transmission in error, please
immediately notify LabOne at the following email address:
securityincidentreporting@labone.com



---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org

> 

---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org