We use the MySQL database and have effectively used the limit clause to work with a limited set of records.
we just store the query condition in the forms and work with that in every page.
- Navneet
[EMAIL PROTECTED] said the following on 18/09/2003 1:56 AM:
It seems that it pulled the whole JDBC resultset into the memory at one time(correct me if I am wrong at this point)
since my data sets will be very huge, I don't think it is a good idea to pull down all the data to the session for paging.
Any better solution /examples?
very appreciated!!
Julie
"Andrew Kuzmin" <[EMAIL PROTECTED]> 09/16/03 09:12 AM Please respond to "Struts Users Mailing List"
To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
cc: Subject: Re: Multipage JDBC result
Hi,
see this link http://jakarta.apache.org/struts/faqs/newbie.html#pager
-- Andrew Kuzmin http://www.java201.com
----- Original Message ----- From: "Jonathan Hawkins" <[EMAIL PROTECTED]>
To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 3:39 PM
Subject: Multipage JDBC result
Howdy,
Any tips as to where I can find code examples of how to break down a large JDBC result
into say 25 rows per page?
Jon Hawkins
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
= = = = = = = = = == = = = = = == = = = = = = = == = = = = = == = = = = This transmittal and any attachments may contain confidential, privileged or sensitive information and is solely for the use of the intended recipient. If you are not intended recipient, you are hereby notified that you have received this transmittal and any such attachments in error and any review, dissemination, distribution or copying thereof is strictly prohibited. If you have received this transmittal and any attachments in error please notify the sender and immediately destroy the message and all its attachments. Any opinions herein expressed may be those of the author and not necessarily of Mizuho Corporate Bank, Ltd (the "Bank"). The Bank accepts no responsibility for the accuracy or completeness of any information herein contained.
= = = = = = = = = == = = = = = == = = = = = = = == = = = = = == = = = =
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
