WebSphere handles that out of the box, if you follow this design: Use session SLSB deployed with TX demarcation set to "requires new". Define a method in the SLSB that issues the EJB QL call, loops through the first X entity references returned by the iterator / enumerator. While looping, use the each entity referense to get the data you want into a set of VO/DTOs and return them to the caller.
The key is to access the iterator within a transaction. /Johan Den 02-11-25 14.54, skrev "Milind Kulkarni" <[EMAIL PROTECTED]>: > 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".
