users@glassfish.java.net

Re: A complex _at_OrderBy definition (JPA/Toplink)

From: <glassfish_at_javadesktop.org>
Date: Mon, 25 Jun 2007 11:47:00 PDT

Hi,

What's the exact problem? TopLink should return the collection in the correct order when retrieving it from the database. But you must maintain the ordering in memory yourself. You can see the SQL generated by TopLink by setting the appropriate log level, please see:

http://www.oracle.com/technology/products/ias/toplink/jpa/howto/configure-logging.html
[Message sent by forum member 'mf125085' (mf125085)]

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