[jboss-user] [EJB/JBoss] - EJB QL
vijaykanth6
do-not-reply at jboss.com
Mon Dec 15 07:43:51 EST 2008
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
More information about the jboss-user
mailing list