I'm trying to do an ORDER BY, using the jboss-ql extension to ejb-ql. My jboss-ql looks something like this:
SELECT OBJECT(c) FROM Category AS c ORDER BY c.name ASC
This doesn't work--it looks like my database (FrontBase) won't order by a column that is not part of the select.
I saw a previous post with a similar problem in Oracle. dsundstrom said:
"This is a known bug. Oracle for some lame reason, requires that all ordered columns also appear in the select. Oracle sucks, but this should be fixed by the time Jboss 3.0.3 comes out." (http://jboss.org/forums/thread.jsp?forum=46&thread=20954&message=3740303)
I'm using JBoss 3.0.4. I am wondering why I am still seeing this problem and if there is anything I can do about it?
