1 Reply Latest reply on Jul 24, 2004 2:16 AM by Alexey Loubyansky

    EJBQL and EJB 2.0 and Order By

    Hideki Mae Newbie

      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.