It is a simple query.But I can not find out what is wrong.
My query is: SELECT OBJECT(a) FROM mySchema as a ORDER BY a.NO

Error msg is:
org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT 
OBJECT(a) FROM mySchema as a ORDER BY a.NO'; - nested throwable: 
(org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "ORDER" at line 1, column 
37.
Was expecting one of:
     
    "," ...
    )]

Anyone can help?

Thanks!

PS: I try to use ORDERBY instead of ORDER BY but has same error.

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834288#3834288

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834288


-------------------------------------------------------
This SF.Net email is sponsored by Sleepycat Software
Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to 
deliver higher performing products faster, at low TCO.
http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to