How do I get a complete list of all tables

robbobkirk · **Joined:** Tue Sep 27, 2005 11:03 am **Posts:** 6

Hibernate version: 2.1

How do I get a complete list of all tables?
I tried calling getAllClassMetaData and this doesn't return any entities that have sets to reference other ones.
My only other thought was try and copy what the export script does but I thought there must be a simpler way.

Help!?

Rob

max · **Posted:** Thu Nov 24, 2005 11:10 am

getAllClassmetadata DOES return classmetadata for all MAPPED classes including those with associations. I will of course not return classmetadata for tables that are not mapped as classes which is the case for many-to-many mappings.

robbobkirk · **Joined:** Tue Sep 27, 2005 11:03 am **Posts:** 6

Thanks for the quick reply. How do I get a list to include those as well?

christian · **Posted:** Thu Nov 24, 2005 12:01 pm

By exploring the metadata available on a JDBC connection.

robbobkirk · **Joined:** Tue Sep 27, 2005 11:03 am **Posts:** 6

OK I've done that. I'd of preferred for hibernate to get me a list as I've now included all tables, including any outside of hibernate but's it probably not a problem.

Rob

d · **Joined:** Mon Jul 04, 2005 5:19 pm **Posts:** 720

Code:

((org.hibernate.mapping.PersistentClass)org.hibernate.cfg.Configuration.getClassMappings().next()).getTable().getName();

TOMBATLECRUISEr · **Joined:** Tue Nov 29, 2005 12:31 pm **Posts:** 75

Hi,

Hibernate version: 3.0.5.

*** Mappings ***

<class name="package.Parent" table="PARENT_TABLE">
...

<list name="childs" lazy="false" table="CHILD_TABLE">
<key column="PARENT_ID"/>
<index type="java.lang.Long" column="POSITION"/>
<element type="java.lang.String" column="value" not-null="true"/>
</list>
...
</class>

<class name="package.Child" table="CHILD_TABLE">

*** JAVA CODE ***

Configuration cfg = ... get the cfg file that contains the mappings above.

Type = "package.Parent";
PersistentClass persistentClass = cfg.getClassMapping(type);

// how can i get the type of the child - in this case somethign should return "package.Child".

// NOTE: I cannot cfg.getClassMappings() and iterate because the input is the parent type.

Just want to know if it's possible.

Thanks.