"markbrazil" wrote : 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.
@BatchSize(size=100) This has helped but there are still 1716 sql statments issued. and each statment includes all tables a,b,c,d,e,f (with outer joins). I also changed my query to include the 3 tables I want "select c from C as c join c.b as b left join b.a as a" Is it possible to limit the query to just this, rather than jboss adding in all outer joins to tables d,e,f ? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3910170#3910170 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3910170 ------------------------------------------------------- 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
