From: <glassfish_at_javadesktop.org>
Date: Mon, 25 Jun 2007 13:58:50 PDT

Hi!
I need to more complex ordering (for my example) and a generated SQL needed as:

select * from A,B,C where B.id = A.fkey and B.fkey=C.id
[b]order by C.myField;[/b]

How to this JPA map? Toplink doesn't recognized @OrderBy ("c.myField");
A sorting this in the memory is workaround for some cases, but I need to sort on the server side.
[Message sent by forum member 'akira_ag' (akira_ag)]

http://forums.java.net/jive/thread.jspa?messageID=223859