Hibernate question: retrieving class name and field name from table_name and column

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

Thread view:

hstanciu@yahoo.com - 21 Nov 2006 21:44 GMT

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

Reply to this Message

ducnbyu - 22 Nov 2006 00:09 GMT

> Hi!
>
[quoted text clipped - 24 lines]
> 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

Reply to this Message

hstanciu@yahoo.com - 22 Nov 2006 16:48 GMT

Thank you very much. I've lost a lot of time to find this :). I'm new
to Hibernate, and I don't understand how this framework become so
popular with so poor documentation. It's very frustrating. I post the
question you asked on the hibernate forum from hibernate.org and I
received no answer. Usually the open source framworks are poor, but
existent. The JBoss was similar, and hibernate is a JBoss splinter.

Thank you once again,

Horatiu

> > Hi!
> >
[quoted text clipped - 45 lines]
>
> HTH

Reply to this Message

ducnbyu - 22 Nov 2006 18:07 GMT

> Thank you very much. I've lost a lot of time to find this :). I'm new
> to Hibernate, and I don't understand how this framework become so
[quoted text clipped - 6 lines]
>
> Horatiu

I agree with you, it appears that most of the API is undocumented
beyond what is auto-generated. API documentation would be so much more
helpful.

Have you read through the manual? Other than searching around the web
and newsgroups and asking questions, the manual seems to be the only
documentation we have to go on. This

http://www.hibernate.org/hib_docs/v3/reference/en/html_single/

opens the entire manual in a single page. I use my browser's find
command to look for things I think I remember having read. The table
of contents is fairly thorough too.

I think the reason hibernate is popular is because of the value of what
it sets out to do and it's open source. You can create very
sophisticated DBMS access methods without writing code specific to the
DBMS you are working in. So you can change the DBMS without touching
any code.

> > > Hi!
> > >
[quoted text clipped - 45 lines]
> >
> > HTH

Reply to this Message

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

Free Magazines