I have two CMP entity beans and there is a 1 to N relationship between them. I know that when you call home methods of a CMP, it would randomly select an instance in the pool, and act like a Stateless Session Bean.
so, I'm using Home method, which calls ejbSelect method, to get a record set from the CMP entity bean. and EJB-QL is used in ejbSelect method.
my question is that: in the ejbSelect Methods of a CMP, I'd write EJB-QL that use CMR references to include attributes of the related CMP in result set. it worked fine, but I don't know behind the scene how it works in container? will it just generate a join select SQL statement, or will it access an instance of the related CMP?