| - EJB QL will not be a step ahead as far as portability is concerned because
| of a missing order by clause. server vendors will most likely provide
| proprietary ways to define the finder queries in SQL, so much for portability.
What is the prevailing wisdom / best-practice for how a finder method like:
findTopFiveSalespeople()
On a Salesperson Entity Bean would be implemented?
~~~~~~~~~~~
The query needs to:
1. ORDER BY some aggregate criterial like sales-by-week-by-salesperson
2. RETURN just to top five salespeople Entity Beans that match
Is this effectively impossible without resorting to proprietary
vendor extension to support the ANSI SQL92 standard query language?
_____________________________________________________________________
Steve Muench - Developer, Product Manager, XML Evangelist, Author
"Building Oracle XML Applications" - www.oreilly.com/catalog/orxmlapp
===========================================================================
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".
