Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

EJB QL Failed  RSS feed

 
vijay bhaskarv
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!