Bugs item #665008, was opened at 2003-01-09 13:16 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=665008&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Markus Menner (morphace) Assigned to: Nobody/Anonymous (nobody) Summary: cache lists Initial Comment: Hi, apparently cache-lists are not cleared correctly. In my case I used JB3.2b3 but it is the same with 3.0.4. My OS: WinXP, JDK 1.4.1_01 Yes, I have the CMP docs ... ;-) Here my standardjbosscmp-jdbc.xml settings: <read-ahead> <strategy>on-find</strategy> <page-size>500</page-size> <eager-load-group>*</eager-load-group> </read-ahead> <list-cache-max>1000</list-cache-max> I use commit-option B, instance per transaction configuration for my CMP EJB's. When you execute a finder (in my case a dynamic EJB-QL finder) JBossCMP uses the read-ahead mechanism to optimize loading. So far, so good. For example three entites A, B and C. A's relationship to B is (A) 1-n (B) with a foreign-key. B's relationship to C is (B) n-1 (C) with a foreign-key. The B entities are read-ahead correctly. Now, the second case: Three entites D, E and B. D's relationship to E is (D) 1-n (E) with a foreign-key. B's relationship to E is (E) n-1 (B) with a foreign-key. When you execute a finder on D the cache-lists from the first finder execution are used! I noticed, that read-ahead is only working for 1-n relationships :-(, not for n-1 (is it a bug ? Anyway, I'll submit it). So normally you should get a query for each B, which is the case if you do not execute the first query, but if you do it, the B's are read-ahead corresponding to the cache-lists of the first query!? I hope that I explained everything enough. TX Markus ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=665008&group_id=22866 ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development