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