The MVCSoft Persistence Manager supports this feature by allowing you to specify a "wrapper method" for the finder with two additional parameters specifying the exact set of records you want. There are a variety of ways you can configure the engine to accomplish this behind the scenes, e.g. "limit/offset" syntax, or scrollable cursors, or simple result set iteration.
This wrapper method can be abstract, because the MVCSoft deployment tools provide an implementation. Alternatively, you can implement the method with code that manually iterates a result collection to get the records you want. This will maintain portability of functionality (although deploying the application on an EJB container with a different persistence mechanism might in practice be a "performance bug"). The MVCSoft PM is available for JBoss, Jonas, WebLogic, WebSphere, Orion, OC4J, and JRun. -Daniel O'Connor On 25 Nov 2002 at 19:24, Milind Kulkarni wrote: > Hi All, > > We have more than 1 million records in Customer Database. We have > requirement that the output of a search query should be limited to 1000 > records only. Can anybody quickly let me know how do you achieve this > using EJB-QL. > > Thanks in Advance ! > Regards, > Milind > > =========================================================================== > 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". > =========================================================================== 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".
