1 Reply Latest reply on Jun 25, 2007 3:18 AM by mladen babic

    EJB3 query ?

    mladen babic Newbie

      Hi people,

      I have four entities and they have ralationship.Example:

      product|-1->--*-|property|-1->-*-|productRuleProperty|-<*---1| textRuleProperty|
      ----------
      and I have query

      "from Product as p join p.properties pp join pp.productRuleProperties prp join prp.textRuleProperty trp where trp.name='Mono' and trp.name='Numeric'"

      And when I execute query I get 0 result.I'm sure that one product has both values in text rule,but when I remove one of these values ,result is ok.How do I resolve this problem?Does anybody know different solution?

      tnx,
      mb