2 Replies Latest reply on May 6, 2003 8:24 PM by Juha Lindfors

    ejb-ql and >, < and like operators

    Lukasz Zeligowski Newbie

      I have some entity bean with custom finder (findByNumber) which should give me a collection of entities which have number 'like' parameter. So I create finder and query is:
      select distinct object(o) from testejb o where o.number like ?1
      I created a JAR and deployment failed... ?1 is not proper...
      Does it mean - I can't use parameters with like?
      But I tried then (just for test):
      select distinct object(o) from testejb o where o.number &gt; ?1
      This also doesn't work.
      What's going on? When I change to string literal ('blahblahblah') or I replace condition to '=' then it works but I need 'like'...
      Have you some ideas?

      TIA
      Lukjel