Hello,

How can I get column name and length of table using hibernate?

My db is postgresql. I would like do this without generating specific db sql
in my java application. Is there any way of doing this using a hql query?

Thanks.

You need to access the meta data in the Configuration object.

[code]
public int getColumnSize(Class mappedClass, String propertyName)
{
Configuration cfg= HibernateUtils.getConfig();
PersistentClass pClass= cfg.getClassMapping(mappedClass);
Property hibProp= pClass.getProperty(propertyName)
Iterator it= hibProp.getColumnIterator();
while (it.hasNext()) {
Column col= (Column) hibProp.getColumnIterator().next();
return col.getLength();
}
}
[/code]