Hi Friends,
I want to retrieve column names of a table through hibernate.How can I do that?
What is the query for that?Please let me know if anyone has idea about it.
Thanks in Advance,
Chirag

Well, you could probably map objects to the system tables that hold the relevent information - but this is of course entirely dependent on the database you're using. What database are you using?

Hi,
I m using MySQL as a backend.If you have any idea about retrieval of column names then please let me know.
Thanx and Regards,
Chirag.

... or he could call org.hibernate.cfg.Configuration.getClassMapping().getProperty().getColumnIterator() ;-)

Try this code:

public static String getColumnName(Class aClass, String aPropertyName) {
// configuration is your hibernate org.hibernate.cfg.Configuration
PersistentClass pClass = configuration.getClassMapping(aClass.getName());

Property pProperty = pClass.getProperty(aPropertyName);
Column column = null;
if (pProperty.getColumnSpan() > 1) {
// Component, more difficult
} else {
column = (Column) pProperty.getColumnIterator().next();
}
return column.getName();
}


Greetingz

STeve

That assumes he has a property mapped to the column name. The original post made no such indication.

To the original poster:
Check out chapter 21 of the mysql manual entitled "The INFORMATION_SCHEMA Information Database" for the info you need. Take a close look specifically at the sections labeled "The INFORMATION_SCHEMA TABLES Table" and "The INFORMATION_SCHEMA COLUMNS Table." It would take a little thought of course, but you should be able to map some objects to those tables in a way which would allow you to perform HQL queries to get the info you need. You'll just need to be careful in your choice of primary keys.