Re: Hibernate question: retrieving class name and field name from table_name and column_name

From:

"ducnbyu" <ducnbyu@aol.com>

Newsgroups:

comp.lang.java.programmer

Date:

21 Nov 2006 16:09:46 -0800

Message-ID:

<1164154186.528287.259240@k70g2000cwa.googlegroups.com>

hstanciu@yahoo.com wrote:

Hi!

I need to get the associated class name and attribute name having
table_name and column_name.

I have the Hibernate mapping file:

<hibernate-mapping>

    <class name="com.esi.masterlist.model.EsiPharmMaster"
schema="HSTANCIU" table="ESI_PHARM_MASTER">
        <id name="esiphmDemSk" type="java.lang.Long" column="ESIPHM_DEM_SK"
length="22">
            <generator class="native">
            </generator>
        </id>
        <property name="aqppExceptionG34sk" type="java.lang.Long"
column="AQPP_EXCEPTION_G34SK" length="22"/>
    </class>
</hibernate-mapping>

I need to get at runtime from the table_name (ESI_PHARM_MASTER) and
column_name (AQPP_EXCEPTION_G34SK) the object class
(com.esi.masterlist.model.EsiPharmMaster) and property name
(aqppExceptionG34sk).

THank you,
Horatiu

Map x =
HibernateSessionFactory.getSessionFactory().getAllClassMetadata();
for (Iterator i = x.values().iterator(); i.hasNext(); ) {
    SingleTableEntityPersister y = (SingleTableEntityPersister)i.next();
    System.out.println(y.getName() + " -> " + y.getTableName());
    for (int j = 0; j < y.getPropertyNames().length; j++) {
        System.out.println(" " + y.getPropertyNames()[j] + " -> " +
(y.getPropertyColumnNames(j).length > 0?
y.getPropertyColumnNames(j)[0]: ""));
    }
}

That will show you all the tables that go with all the classes in your
schema and all the class properties that go with columns in your
tables.

You can search through that or pre-load a more searchable structure
depending on your performance requirements.

HTH