Re: web app paging through results

["Dave Wall" <dawall@xxxxxxxxxx>]

This sure sounds like a leak.  You have a reference to the result set in
your session data.  The result set (both the Java object and the actual
object in the database) will not be cleaned up until the reference goes
away.  There are some techniques you could use to detect idle result sets
and clean them up, but if you don't do something that resource will be in
use.  In the worst case it will be in use until the web server is
restarted.

David Wall
AS/400 Toolbox for Java


Glenn Holmer <gholmer@weycogroup.com>@midrange.com on 05/29/2001 02:58:41
PM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   Java400 mailing list <JAVA400-L@midrange.com>
cc:
Subject:  web app paging through results



I am implementing an order status lookup for our salesmen and plan to
use the JDBC 2.0 scrollable result set for this.  What I'm thinking of
doing is passing the result set around in a session variable, so the
user can just hit "next 10" and "previous 10"; the session would also
keep track of "page number", which I could use for ResultSet.absolute()
when displaying each page.

My question is, what happens if the user just goes to a different site
instead of exiting this function?  What happens to the ResultSet? Is
this a resource leak on the '400?  How is this sort of thing usually
handled?

--
____________________________________________________________
Glenn Holmer                          gholmer@weycogroup.com
Programmer/Analyst                       phone: 414.908.1809
Weyco Group, Inc.                          fax: 414.908.1601
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---