Hello all,

I'm currently working on a part of a J2EE web-based application using Spring and Hibernate. Specifically, I'm trying to implement auditing within the application. To that end I need to pull the database name, schema name, and table name which should be contained within the mappings for the domain classes. I'm just unclear on how to get this information for read-only purposes.

I've done some searching here in the forums and lots of warm fuzzy time with the JavaDocs but I still don't see how to get that information. Anyone have any idea how to go about doing that?

Thanks,
C

By far the "easiest way" is to maintain a reference to the Configuration from which you generated the SessionFactory, which you can then use to call Configuration.getClassMapping(Class), which returns an instance of PersistentClass representing the mapping information defined for the requested class. PersistentClass has exposed methods to get all the information you are after.

If you don't have the Configuration available, it is still doable. Basically, you need to cast the session factory to type SessionFactoryImplementor and call it's getPersister(Class), which returns an instance of ClassPersister. Cast the ClassPersister to EntityPersister and call its getTableName() method. The result of getTableName() is the qualified table name.

Thanks for the point in the right direction, Steve! It's mucho appreciated.

C