Jon --
We are sending the last object received on subsequent requests for Db
"pages." The Data server uses this data to condition the WHERE statement to
the row(s) greater than this one.
J. Scott Stanlick
Lead Software Engineer
Enterprise Rent-A-Car
-----Original Message-----
From: A mailing list for Enterprise JavaBeans development
[mailto:[EMAIL PROTECTED]]On Behalf Of Jon Lee
Sent: Tuesday, April 18, 2000 10:53 AM
To: [EMAIL PROTECTED]
Subject: Paging large database result sets
Currently looking at the best way to deal with http requests for result sets
obtained from an SQL (DB2 AS400) database.
I am using a stateful session bean to access this database.
I am sure this must be a common issue.
For example, a request effectively asks for a 500 row table to be returned.
I want to return 50 of these rows in a response to the user, and then give
them the option of returning the next 50 or previous 50, etc.
a) I can limit the number of rows being returned using setMaxSize() on my
prepared statement, but I am then unsure of how I can obtain the next set of
records, when requested, as JDBC does not seem to allow me to do this
(anyone know anything about this?)
b) I can bring back the whole 500 row result set, store it on the StatefulSB
as a cachedresultset(?) or as a Collection of some kind. Hopefully
weblogic's container would effectively manage the memory use that this would
involve, but I would save myself trips to the database (offsite).
This must have been solved many times before, what do people think?
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
