Hello,
I would like to use the JBoss-QL ORDER BY STATEMENT.
* @jboss.query
* signature="java.util.Collection findAllOrderByCDesc()"
* query="SELECT OBJECT(obj) from Table1 obj ORDER by obj.C DESC"
The Table1 consists of three fields A, B, C.
The fields A and B are in the primary key and my order by works if I use order by on A or B.
But if I try to make an order by on field C which is not in the primary key I get the following error:
Find failed: java.sql.SQLException: ORDER BY column (C) must be in SELECT list.
How could I make an "order by" on a non primary key field.
Thanks in advance for any help.
Regards,
Stefan.