0 Replies Latest reply on Dec 15, 2008 7:43 AM by vijay vykuntam

    EJB QL

    vijay vykuntam Newbie

      Hi All,
      I have got the following error while executing the EJB QL
      My EJB QL:SELECT distinct OBJECT(o) FROM com_afl_global_entity_Partner o WHERE o.id IN (-1,780,1005,1091,1097) ORDER by o.name

      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> ...

      Is negitive number not valid in the IN parameter in EJB QL?
      My query query is well executing in the oracle.
      Please help me out from this crisis

      Thanks in Advance