question about CMP?

[Robert Strong]

I'm using BEA Weblogic8.1.

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?

thank you!!!

[Sudhir V]

The implementation part is not specified in the EJB Spec and hence its upto the vendor. I would think they would generate a join sql query.

[Edy Yu]

is there a way in WebLogic to see the container generated code?

I know in WebSphere Studio, you can ...