Could someone confirm if it is normal behaviour or bug or my wrong configuration?!?
It really kills performance.
I am having the same problematic behaviour in JBoss 4.0.2. In fact, I have the impression that it worked in earlier versions. If only I knew for sure when it worked...
make sure you are in a transaction with "Required" attribute setting. Also dont use the EJBQLToSQL92DCompiler in deploy desc.
If that doesnt work, try CMR left join read ahead feature. that definitely works. basically get your B attrs when you get your A's into the global cache. use 3.2.7, not 3.2.6 that has some relevant bug fixes.
make sure you are in a transaction with "Required" attribute setting
i've checked and it is 'required'.
Also dont use the EJBQLToSQL92DCompiler in deploy desc.
As triathlon98 says, it is similar in 4.0.2 so probably 3.2.7 also. And I have 100+ beans, it is too painfull to make CMR left join read ahead, and IMO such simple CMR as it is now should work :)
I've checked 3.2.7 - the same situation.
I think it is time to issue bug.