Is there any app server, tool, coding style, etc.... ANYTHING that will help
us have a standard way of pagination? It seems that pagination is a very
typical problem and should be able to handled generically. I know both
Oracle and MySQL (I know that's only two of many) can support this in
queries, but... It is such a nuisance to have to write pagination support
everywhere we need it--and I haven't discovered a way to do it elegantly
(ie. you have to go out and get the total rows completely separately, code
it all yourself, and have to put it in the session bean which is a nuisance
when the finders are in the entity beans).
Anyway, anyone have any ideas on a good way of doing pagination in EJBs?
Thanks,
Joel Shellman
http://www.ants.com/90589781
----- Original Message -----
From: "David Wall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 22, 2000 9:05 PM
Subject: Re: HTTP Session Vs Stateful Session Beans
> > And a question... Are you trying to make this big query, and then split
> the
> > results to show a small amount of them in every 'screen'...
> > because if so, what you need is PAGINATION, that is, to be able to split
> > your big query into smaller querys (like altavista does to 'show' a
> million
> > hits... ten a page..)
>
> But is there really any good scheme for pagination with an SQL DB? Some
DBs
> have a LIMIT clause, but still there's a good chance the entire result set
> has to be retrieved before the subset is returned, unless the DB has nice
> optimizations and the WHERE clause is on an indexed field.
===========================================================================
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".
