Re: Are there any patters for pager design with EntityBeansproviding access to the database?

2002-03-05 Thread Bryan Field-Elliot
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

Re: Are there any patters for pager design with EntityBeansproviding access to the database?

2002-03-05 Thread Barry Glasco
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: