I'm using JBuilder 8 + JBossOpenTool + JBoss3.2.1
When deploying the ear file to JBoss I got error like below:
How to correct it ?
org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'select object(o) from Foo o order by o.col1'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "order" at line 1, column 29.
Was expecting one of:
The ORDER BY clause was not included in the specification due to "problems dealing with the mismatch in ordering behavior between the Java language and databases." -- Enterprise JavaBean, 3rd Edition, page 251.
A way to get around it is to retrieve a collection of data and manipulate it based upon your ordering criteria.