To all,
I'm using JBoss 3.2.4 and EJB 2.0. I have a EJBQL statement:
"select distinct object(usr) from DWMUsrAdminSchema as usr, in (usr.userComp) as uComp where uComp.componentKey =?1 order by ?2 ". I read in another thread that JBoss extends EJBQL so that "order by ?2" would be legal even though it is EJB 2.0. When I deployed it, it returned errors. I also tried @jboss.query tags but it returned the same errors. The select statement worked only if I specify the field name for "?2". Is there a way to update EJB 2.0 to EJB 2.1 so that "order by ?@" works?
Thanks in advance for any help you can give me.
Parameters are not allowed in ORDER BY even in EJBQL2.1.
http://www.jboss.org/wiki/Wiki.jsp?page=EJBQL21