Getting the table name and column name using the class name

udayaprakash · **Posted:** Mon Apr 17, 2006 9:17 am

Hi,

I would like to know how to retrieve the table name and column name for a particular class if I know the class name and the property name corresponding to the column name.

Regards

Uday

edward.yakop · **Posted:** Tue Apr 18, 2006 3:40 am

Hi,

Use ClassMetaData API.
http://www.hibernate.org/hib_docs/v3/ap ... adata.html

For example,

Code:

ClassMetaData persistMetaData = sessionFactory.getClassMetaData( PersistentClass.class );
System.out.println( "Entity table [" + persistMetaData.getEntityName() + "]" );

Regards,
Edward

CWitherow · **Posted:** Tue Apr 18, 2006 11:29 am

The only way I can see to do it is to start from the Configuration and then step into the related collections. Note that not all properties have a column, i.e. one-to-one.

Code:

for (Iterator it1 = config.getClassMappings(); it1.hasNext(); ) {
  PersistentClass pc = (PersistentClass)it1.next();
  System.out.println("Table is " + pc.getTable().getName());
  for (Iterator it2 = pc.getPropertyIterator(); it2.hasNext(); ) {
    Property property = (Property)it2.next();
    System.out.println("Property is " + property.getName());
    for (Iterator it3 = property.getColumnIterator(); it3.hasNext(); ) {
      Column column = (Column)it3.next();
      System.out.println("Column is " + column.getName());
    }
  }
}

Good luck,
Curtis ...

udayaprakash · **Posted:** Tue Jun 13, 2006 5:48 pm

Hi CWitherow,

I am using spring LocalSessionFactorybean which can give me the Hibernate configuration object. But I am not able to get this object from application Context. It throws ClassCastException when I try to get this from applicationContext. Is there is any other way of getting access to the Configuration in the Hibernate Interceptor object.

Regards

Uday