0 Replies Latest reply on Dec 11, 2008 12:21 PM by vijay vykuntam

    Ejb QL Failed

    vijay vykuntam Newbie

      Hi All,

      When I execute dynamic ejb ql as follows


      SELECT distinct OBJECT(o) FROM com_afl_global_entity_Partner o WHERE o.id IN (-1,780,1005,1091,1097) ORDER by o.name

      I got the following error


      org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "-" at line 1, column 85.
      Was expecting one of:
      "ABS" ...
      "COUNT" ...
      "MAX" ...
      "MIN" ...
      "AVG" ...
      "SUM" ...
      "LENGTH" ...
      "LOCATE" ...
      "SQRT" ...
      "MOD" ...
      "(" ...
      <INTEGER_LITERAL> ...
      <FLOATING_POINT_LITERAL> ...
      <NUMERIC_VALUED_PARAMETER> ...
      <NUMERIC_VALUED_PATH> ...


      Please help me out,why is it not consider the "-1" as negitive number?

      Thanks in Advance