You didn't specify whether you want to do client-side or server-side paging. Assuming you want to pull the whole resultset in one shot, but have a paged presentation, check out the "Struts Layout" taglibs. They have a very handy pager widget that uses javascript and tags. If you want to do server side, this is really more of a database issue than a struts issue, and a lot will depend on what database you are using. The downside is you have to do a round-trip to the server for the next page. Search on Google for "Scrollable" resultsets. Almost all JDBC drivers support them. Another method is to specify a LIMIT offset in your query to specify the number of rows you want returned and where in the resultset you want to return from. Exact syntax is database-specific.
David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:27 PM To: Struts Users Mailing List Subject: Re: Multipage JDBC result 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. = = = = = = = = = == = = = = = == = = = = = = = == = = = = = == = = = = --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
