[jboss-user] [EJB 3.0] - Using a parameter as order by column

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...