How can I read dynamic values from a mapping file?

Purpose: I need to read the locale from the system. The mapping file contains mapping for two tables one which has the description and id and the other table has the languages associated with that id.

For eg, if an id has French language associated with it then the French user should be able to see French description for that id. Then if US or any other user wants to see the description for the same id then it should show in English(default).

I just want to use session.createQuery("from table") while retrieving data. Right now I am using the <formula> tag to read the locale dynamically in the mapping file. But it seems not to be working.

The other problem with session.createQuery("from table") statement is, it is not doing a left outer join on the tables. But if I use session.load(Table.class) method then while loading class it does an outer join as there is a mapping for this in the hbm.xml file. How can I achieve this in createQuery method?

Please let me know if any body has any answers for these.

[/code]

Thanks.

I actually dont want to use the join inside the query as I am also getting the table name dynamically. So, I wouldn't be knowing what table it is associating with in the mapping file.