0 Replies Latest reply on Jan 3, 2003 5:51 PM by Jon Ford

    CMP/CMR 1-many generating 2 SQL calls on findByPrimaryKey

    Jon Ford Newbie


      I tried to post earlier but it didn't take. So, if this shows up twice - sorry. Calling findByPrimaryKey on the SalesOrder EJB (relationship shown below) is generating two SQL calls: select to load sales order and select to load the line items. I'd like one select to load the sales order and its line items on a call to the sales order findByPrimaryKey. I'm sure that I am probably missing something simple. The deployment descriptors are generated by XDoclet and the beans are CMP in the default CMP 2.x container w/oracle 8.1.7.