I know now that fetch=LAZY is not an option for remote clients. However I still have the following
A mapped to B A mapped to F B mapped to C B mapped to D B mapped to E Querying C and getting details from B and A. When I run this query it fetches 1696 rows. This however issues 3392 sql queries one for C-b-a and one for the other joins from b. Is there a way I can fetch groups of records with ejb3. I could do this with xdoclet & ejb2.1 with the read-ahead page-size option. Is there a similar option for ejb3 ? I don't really want to be excuting this number of sql statments against the database. Regards, Mark. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3910163#3910163 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3910163 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
