I got a simple question concerning EJB-QL. The problem is the following:
in the J2ee tutorial provided by SUN they sqy there is an ORDER BY clause supported. However, when deploying an EJB-QL query which contains an ORDER BY clause I get an exception saying that "ORDER" is unexpected. I use JBoss 3.2.3.
ORDER BY is supported in EJB2.1, which is not added into jboss until version 4.0. jboss3.2.3 runs EJB2.0. You could use JBOSSQL a superset of EJBQL to do it if you don't want to upgrade to the release candidate 1 of jboss 4.0