Fast Lane reader and page iterator pattern's using JDBC 2.0 and a tag that you can find by searching the archives.
----- Original Message ----- From: "Bryan Field-Elliot" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "'Struts Users'" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 11:18 PM Subject: Re: Are there any patters for pager design with EntityBeansproviding access to the database? > The best approach is to use a database-specific extension (since paging > is not part of SQL standard syntax). > > I use PostgreSQL which has very nice and easy paging support (using > LIMIT and OFFSET keywords). > > I've tried to do it once before using Oracle but had some trouble (as I > recall the "rownum" didn't work as intuitively as you would hope or > expect). > > The fallback position is to load the whole resultset into memory and > store it as a session variable. This is a bad practice if the resultset > can be large (a thousand rows or more for example). > > Bryan > > On Tue, 2002-03-05 at 21:12, Alex Paransky wrote: > > I was wondering how people are implementing paging capability in struts. In > other words, if the result set comes back with 2000 rows, how do you display > page 4 of 100 with 20 results per page? > > Is writing custom SQL commands to depend on ROWNUM or something of that sort > always required? Are there any easy mechanism to do paging? Would this be > a good place to use a Statefull Session Bean and store it in to the session? > > Thanks. > > -AP_ > http://www.alexparansky.com > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>