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".
