Can parameterize table name in "createSQLQuery"?

kyb · **Posted:** Tue Feb 21, 2006 2:22 am

first, sorry for my poor english..

I must use native sql using hibernate.

My sql like this..

Code:

select * from XXX Where dd=:dd and gg=:gg

Hear the table name(XXX) change dynamically at run time(YYY,ZZZ...).

but the all the XXX...ZZZ table schema are same.

I want to parameterize this table name like other parameters, if it is possible.

It is not recommended sql string composite out of "createSQLQuery" method.

thanks in advance.

max · **Posted:** Tue Feb 21, 2006 2:47 am

no, not possible.

what about creating a view that you can select from which maps to the underlying table.

kyb · **Posted:** Tue Feb 21, 2006 3:33 am

hm... I see that's not possible.
Thank you for your answer.