0 Replies Latest reply on Mar 21, 2005 9:22 AM by pepone moiti

    EJB-QL upgrade on JBOSS3.2.1

    pepone moiti Newbie

      Hello, I have a cMP Bean, but I cannot deploy it because I have this error on my query :
      org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(a) FROM TsaGed a where a.tsaver='0' and a.tsavis='01' and a.tsatbl = ?1 order by a.tsarga'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "order" at line 1, column 87.
      Was expecting one of:

      "AND" ...
      "OR" ...
      )

      I think, it doesn't understand order by. So what to do ? Is there any way to do this ? Shall I have to upgrade EJB-DL ? What is the solution ?

      PS : I have the same error when I want to do a.tsavis like '%1%', it doesn't understand like.

      Thx.

      Pierre.