Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EJB-QL and ORDER BY

664946Oct 13 2008 — edited Nov 17 2008
Hi all,
this is my first post in this forum.
I have a question:

Is there a way in ejb-ql to make a query like this?

SELECT a FROM Test a ORDER BY :field

and then pass the parameter "field"?

I need this because i want to implement pagination in my swing jtables.
But when i need to sort data the only way that i've found is re-query with another order by param.
If you want to suggest me another way to accomplish this, let me know!

Very thanks, Eros.

P.S.: I'm using Netbeans with Oracle Toplink Essentials

Edited by: user6103941 on 13-ott-2008 15.16
This post has been answered by Doug Clarke-Oracle on Oct 14 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2008
Added on Oct 13 2008
3 comments
832 views