Hi all,
I am developing a Rich Client talking to my jboss server via Session Beans. Now within my
Session Bean, I have the following Function:
| public List<Domaindata> getAllDomains(String orderByColumn)
| {
| Query query = em.createQuery("select d from Domaindata AS d ORDER BY
:column");
| query.setParameter("column", orderByColumn);
|
| return query.getResultList();
| }
|
on the client side i am calling this function through its remote interface
| DomainRobotRemote robot =
CommunicationHandler.getInstance().getDomainRobot();
| List<Domaindata> domains =
robot.getAllDomains("name");
| for (Domaindata d : domains)
| {
| theNode.add(new DefaultMutableTreeNode(d.getName()));
| }
|
I can see the query translated by hibernate as
| 16:08:06,302 INFO [STDOUT] Hibernate: select ... borc.DOMAINDATA domaindata0_ order
by ?
|
but the result list is not ordered.
If I explicitly order by a specific domain as in
| public List<Domaindata> getAllDomainsByName()
| {
| return em.createQuery("from Domaindata domain order by
domain.name").getResultList();
| }
|
Everything is working fine. Isn't it possible to dynamically say what Column I want
the Result list to be orderd by?
Any Help is highly appreciated.
Juergen
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4025856#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...