Get table column names in Hibernate

hibernate, java, json

Solution

To get the `column names`, first you need to find the `properties` of the entity using `org.hibernate.metadata.ClassMetadata`:

ClassMetadata classMetadata = sessionFactory.getClassMetadata(AppTaskConfig.class);
String[] propertyNames = classMetadata.getPropertyNames();

where `propertyNames` is an array of Strings representing the property names of `AppTaskConfig`.

Now using Hibernate `org.hibernate.cfg.Configuration` object you can find the column names of the `properties`:

for (String property : propertyNames) {
    Configuration configuration = sessionFactoryBean.getConfiguration();
    PersistentClass persistentClass = configuration
                    .getClassMapping(Details.class.getName());
    String columnName = ((Column) persistentClass.getProperty(property)
                    .getColumnIterator().next()).getName();
}

Problem

I am using hibernate `Criteria` class to get all records of table : ``` Criteria criteria = session.createCriteria(AppTaskConfig.class) ``` I would like to get column names also as I need to convert result set into JSON format.

Original source

Related problems