1 Reply Latest reply on Dec 3, 2002 5:48 PM by Alvaro

    2 terms of Entity-Beans with OR in EJB-QL?

    Vanessa Newbie

      I have a problem when i try to connect in a EJB-QL statement two terms of
      Entity-bean instances with OR I don't get a result.
      But each of the two statements alone returns one result.

      SELECT OBJECT(k) FROM KustBean k
      WHERE (k.implKUSTVorgaenger.implId LIKE '1038574705549+3523611')
      --> this works!

      SELECT OBJECT(k) FROM KustBean k
      WHERE ((k.implKUSTVorgaenger.implId LIKE '1038574705549+3523611') OR (k.implRootVorgaenger.implId LIKE '1038574705519+1753714') )
      --> no results!

      I use the JBoss 3.02