retrieving column names from a table

cjenkisas · **Joined:** Tue Dec 21, 2004 3:30 am **Posts:** 2

hibernate 2.1.7

mysql 4.0.18

I'm having trouble searching through Google, the forums, and the API for a method to retrieve all the column names from a table in Hibernate. Would anyone know of a simple way to do this? I can build the native mysql sql query to do this for Hibernate, but I'm sure I'm missing the easier route.

Thanks for your help,
cjen

max · **Posted:** Tue Dec 21, 2004 5:13 am

look at the Configuration object - it allows you to gain access to all the class metadata on which you can find all the columns a class map to...

cjenkisas · **Joined:** Tue Dec 21, 2004 3:30 am **Posts:** 2

Arg... Thanks max. It was right there in the FAQ and I overlooked it.

http://www.hibernate.org/118.html

Here's how you do get it if anyone is interested.

Code:

Configuration cfg = new Configuration().addClass(Table.class);
sessionFactory = cfg.buildSessionFactory();
PersistentClass pert = cfg.getClassMapping(Table.class);
Iterator iter = pert.getPropertyIterator();
           
while ( iter.hasNext() ) 
{
    Property prop = (Property) iter.next();
    System.out.println("Column Name: " + prop.getName());
}

cjen