Creating a dynamic query

citynomad · **Joined:** Thu Oct 27, 2005 6:01 pm **Posts:** 15

Hi all,

I have the following HQL query:

Code:

select distinct budget.clubType 
from Budget budget 
where budget.season.budgetYear = :budgetYear 
and budget.season.seasonCode = :seasonCode

(The query is actually more complex, so I'm abbreviating here for simplicity's sake.)

The query works and does what I need. But now I would like to use the same query to retrieve clubTypes from different tables, so I need to supply the entity specified in the FROM clause dynamically. Hibernate query parser complains if I do "from :entity ent", so I guess that's not allowed. I suspect I'll need to switch to using the Criteria API instead of HQL to implement that, but I'm not sure how to do this.

Any help will be appreciated.

Eugene

P.S. I'm using Hibernate 3.1.2.

kochcp · **Posted:** Wed Mar 08, 2006 4:22 pm

String concatenation still works

Code:

session.createQuery("select distinct " + entityName + " from " + otherVariable + " where bla bla bla");

citynomad · **Joined:** Thu Oct 27, 2005 6:01 pm **Posts:** 15

Thanks Chris!

That will certainly work. But I was hoping to find a more "Hibernate-native" solution - perhaps as part of a general habit of treating each problem as a learning experience. And there is plenty of learning that I still have to do when it comes to Hibernate! :-)

Thanks again.

Eugene

kochcp · **Posted:** Wed Mar 08, 2006 6:50 pm

criteria work very well for dynamic queries, but I think a simple solution is sometimes the key.

Also, Criteria and query parameters happening 2 joins away are nasty.