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