Hi, I have looked around trying to find how to modify in runtime a query that I use in an hbm.xml file. I need to change it because the query must adapt to the user's requests, e.g: to change the sort order of the query or to modify the where clause conditions. It is quite impractical to simply add new querys to satisfy each case or to use a stringbuffer in the code, it is supposed to be better not to hardwire the query. Can someone help me with this?

Hibernate version: 3.0


Name and version of the database you are using: PostgreSql 8

Have you tried using the Criteria API instead of using a named query? This is exactly the kind of thing that Criteria stuff is made for.

http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#querycriteria