0 Replies Latest reply on Feb 22, 2003 7:01 PM by Dzidas

    using IN expression

    Dzidas Newbie

      Hello,
      I try use this:
      <![CDATA[SELECT OBJECT(o) FROM GroupEjb o WHERE o.id IN (?1)]]>, but get follows error. If I use String type row, it will work ok.
      I want get some GroupsEjb from database. (ex: where id in (2,5,1,5,n...))
      Is maybe another solution?
      error:
      I Depend On:
      Depends On Me: org.jboss.deployment.DeploymentException: Error compiling ejbql;
      - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountere
      d "o.id" at line 1, column 42.
      Was expecting one of:
      "NOT" ...
      <STRING_VALUED_PATH> ...
      <COLLECTION_VALUED_PATH> ...
      "(" ...
      "CONCAT" ...
      "SUBSTRING" ...
      <BOOLEAN_VALUED_PATH> ...
      <DATETIME_VALUED_PATH> ...
      <ENTITY_VALUED_PATH> ...
      <IDENTIFICATION_VARIABLE> ...
      <NUMERIC_VALUED_PATH> ...
      )]
      bye.