[jboss-user] [EJB/JBoss] - Ejb QL Failed

[vijaykanth6]

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


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4196008#4196008

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4196008