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

[vijaykanth6]

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

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

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