Hi, There is a pattern over here. However this is to kind of cache the results and then show them page by page. However I doubt if one would like to invoke a query that keeps that number of records in memory that you want.
Hi, There could be 2 options in here: 1. StateFull SessionBean methods return partial result, for example for every N records. 2. Using JMS Queue Session bean method execute query, getting data from ResultSet and periodically sending result object to queue. Regards, Milind