3 Replies Latest reply on Jun 8, 2004 2:47 AM by Alexey Loubyansky

    CMP - wrong data with jboss > 3.2.1

    Marcus Schiesser Newbie

      hi folks,

      i have a problem that occurs only with jboss >= 3.2.3 (including 4.0) and my molimo (http://www.molimo.de) application (source available) - jboss 3.2.1 works fine.
      there is a entity bean called ThingBean, with two 1:n relation to itself (one in attribute father, one in attribute type)

      it has the followin query method defined:

      <ejb-ql>SELECT Object(t) FROM ThingBean AS t WHERE t.father=?1 OR t.type=?1</ejb-ql>

      here's the relationship for type (analog for father)

      <ejb-relation-name>Thing - Type</ejb-relation-name>
      <ejb-relationship-role-name>Thing - Type.thing</ejb-relationship-role-name>
      <ejb-relationship-role-name>Thing - Type.type</ejb-relationship-role-name>

      now the problem:

      imagine a thing has one child (one thing with father==this exists, verified in database), so a call to
      should deliver a collection with one child (it does this with 3.2.1)
      but beginning with 3.2.3 it does return a collection of 254-times the same thing.

      hope this helps you folks -