[jboss-user] [Beginners Corner] - EJB_QL comparing a constant to an input parameter

[lmmartin65]

When I try to deploy to JBoss I am getting the error:

 - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "= sx.routeId ) AND ( sx.ftsegId =
x.ftsegId ) AND ( s.routeId = 1 ) AND ( ( ( 0 =" at line 1, column 89.
vm 1    | Was expecting one of:
vm 1    |     ")" ...
vm 1    |     "+" ...
vm 1    |     "-" ...
vm 1    |     "*" ...
vm 1    |     "/" ...
vm 1    |     "=" "+" ...
vm 1    |     "=" "-" ...
vm 1    |     "=" <NUMERIC_VALUED_PATH> "*" ...
vm 1    |     "=" <NUMERIC_VALUED_PATH> "/" ...
vm 1    |     "=" <NUMERIC_VALUED_PATH> "+" ...
vm 1    |     "=" <NUMERIC_VALUED_PATH> "-" ...
vm 1    |     "=" <NUMERIC_VALUED_PATH> "AND" ...
vm 1    |     "=" <NUMERIC_VALUED_PATH> "OR" ...
vm 1    |     "=" <NUMERIC_VALUED_PATH> ")" "AND" "NOT" ...

It seems to deploy and run fine on Weblogic.

The error seems to be with (0 = ?2)  where I am comparing a constant (int) to an input parameter(int).  How do I accomplish this with JBoss?

SELECT Object(s) FROM Subroute s, SubrouteXref sx, FtsegCountyXref cx  WHERE ((s.routeId = sx.routeId) AND (sx.ftsegId = cx.ftsegId) AND (s.routeId = ?1) AND (((0 = ?2) AND((s.direction = 'EASTBOUND') or (s.direction = 'NORTHBOUND') or (s.direction = 'BIDIRECTIONAL') or (s.direction = 'ONEWAY'))) OR ((1 = ?2) AND ((s.direction = 'WESTBOUND') or (s.direction = 'SOUTHBOUND') or (s.direction = 'ONEWAY'))))AND (cx.containingCountyNumber = ?3) AND (sx.status = 'ACTIVE'))

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

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