0 Replies Latest reply on Mar 10, 2003 11:04 AM by Peter Johnson

    ORDER BY, jboss-ql, and SELECTs

    Peter Johnson Newbie

      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?