Forget this problem. I am nearly certain that it was caused by crossing transaction boundaries. That is: the finder executed in one transaction, and the sort occurred in another transaction. When I moved the sort into the session bean doing the finding, it worked much better. Ciao, Jonathan O'Connor XCOM Dublin
Jonathan.O'[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 13.01.2004 14:25 Please respond to [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject [JBoss-user] Getting load groups to work? [auf Viren geprüft] Alex (Oracle of the CMP engine!), I'm trying to get these load groups working in JBoss 3.2.2. I've successfully set up two load groups on a CMP entity bean, "sortKeys" and "most". sortKeys has 3 fields, and most has most, but not all, of the other CMP fields. I have set read-ahead on my query (@jboss.declared-sql page-size="40" eager-load-group="sortKeys" strategy="on-find". This correctly does a "SELECT PK, SORT_KEY1, SORT_KEY2, SORT_KEY3 FROM T". I then do the following: Object[] sortingArray = collection.toArray(); Arrays.sort(sortingArray, comparator); However, now, I see that during the sort() call, JBoss goes and fetches all the columns for each object that was found. Why should it want to load all these objects? Ciao, Jonathan O'Connor XCOM Dublin ------------------------------------------------------- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
