sql update and table names

Will_Gayther · **Joined:** Mon Sep 15, 2003 6:55 pm **Posts:** 29

Is there a way, programatically, to find the table name for a given class? For example, what table is the com.mine.Bob class mapped to?

I am trying to do an sql update. I know that the table name is in the mapping file, but I would like to be able to change it in the future without having to remember to change this sql query.

michael · **Posted:** Fri Dec 26, 2003 1:58 pm

You could get it from the Configuration Object i think by calling getClassMapping(<your class>).getTable().getName(). I dont think there is a way to get it from the SessionFactory or the Session

Will_Gayther · **Joined:** Mon Sep 15, 2003 6:55 pm **Posts:** 29

Thanks! That works.

I can't find a way to get it from the SessionFactory or the Session either - you would think there would be a getConfiguration() method. This is what I ended up doing:
DatabaseHelper.getConfiguration().getClassMapping(LinkDAO.class).getTable().getName();

michael · **Posted:** Sat Dec 27, 2003 6:09 am

You could to somethink like this, I think (relying on Hibernate internals):

Code:

SessionImpl impl = (SessionImpl) session;
Loadable loadable = (Loadable) impl.getClassPersister(<your class>);
String fromFragment = loadable.fromTableFragment("an_alias");

Be warned however, I have not tested this, don't know if this works and this may change anytime. Use on your own risk :)

max · **Posted:** Sat Dec 27, 2003 6:42 am

...and that code will return a string on the form "table1 an_alias_0, table2 an_alias_1, ..." if the class is mapped to multiple tables. (if i remember correctly)