You can ORDER BY fields that are in SELECT, i.e. in your case ORDER BY name. It's bug.
There is no reason for this limitation. It's now fixed.
Index: JDBCEJBQLCompiler.java
| ===================================================================
| RCS file:
/cvsroot/jboss/jboss/src/main/org/jboss/ejb/plugins/cmp/jdbc/JDBCEJBQLCompiler.java,v
| retrieving revision 1.10.2.48
| diff -r1.10.2.48 JDBCEJBQLCompiler.java
| 1829,1832d1828
| < else
| < {
| < throw new IllegalStateException("Unexpected select object: " +
selectObject);
| < }
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843583#3843583
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3843583
-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
