0 Replies Latest reply on Mar 4, 2003 12:00 PM by Paul Morris

    CMP loading wrong entity

    Paul Morris Newbie

      I running JBoss 3.0.6 and using CMP. I have a 1-to-many relation between 2 beans and have defined an ejb-ql query like (note the beans on the many side have a many-1 relation with another bean).

      SELECT OBJECT(proxy)
      FROM UserListEntity list, IN(list.entityCollection) proxy
      WHERE list.PUID=?1 AND proxy.subjectEntity.PUID=?2

      In looking at the JBoss log the SQL for this query is generated correctly. It succeeeds and finds the correct primary key for the proxy item. JBoss then tries to load the "list" entity using the primary key of the proxy entity the SQL statement returns. It should be loading the "proxy" entity. This finder is defined on the home interfacef or the "list" entity.

      Does anyone have any idea, what I've done wrong. If the relation in the ejb-jar is wrong, I woulnd't expect the correct SQL to be generated as it is.