What's up with EJB-QL... doesn't work!

Discussions

EJB programming & troubleshooting: What's up with EJB-QL... doesn't work!

  1. What's up with EJB-QL... doesn't work! (2 messages)

    Hi All, I am trying to executing Ejb QL Query in jboss server. I have got the query as follows "SELECT distinct OBJECT(o) FROM com_afl_global_entity_Partner o WHERE o.id IN (-1,5,10,780,1005,1091,1097) ORDER by o.name " giving the error as 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" ... "(" ... ... ... ... ... Please help me ,I am in urgent need Thanks in Advance
  2. -1 is incorrect
  3. Hi[ Go to top ]

    Is negitive number is invalid for ejb ql IN function? when I execute the query in the normal oracle it is executing.Please could you tell me why negitive numbers are not allowed in the IN function for ejb ql?