Get column name of property mapped with Hibernate

Question

How can I access the Hibernate mapping of my model to find out the column name of a property?

The column name is not specified in the mapping so Hibernate generates it automatically - I would like to create a native SQL statement including this column name.

score 16 · Accepted Answer · answered Jan 07 '10 at 21:43

16

Thanks to Jherico I found out how to do that:

((Column) sessionFactoryBean.getConfiguration().getClassMapping(Person.class.getName())
        .getProperty("myProperty").getColumnIterator().next()).getName();

answered Jan 07 '10 at 21:43

Thomas Einwaller

8,873
4
40
55

3

What is "sessionFactoryBean" here? I am sure it is not sessionFactory. – instanceOfObject Feb 06 '14 at 12:10
it can be either sessionFactory or SessionFactoryBean, it depends on the version – Shilan Mar 29 '16 at 14:26

score 3 · Answer 2 · answered Jul 20 '13 at 00:24

3

((AbstractEntityPersister) sessionFactory.getClassMetadata(o.getClass()))
    .getPropertyColumnNames(property)[0];

answered Jul 20 '13 at 00:24

B T

57,525
34
189
207

1

You should use `Hibernate.getClass(o)` rather than `o.getClass()` in case `o` is a proxy. – Luke Maurer Jun 24 '14 at 19:50

score 1 · Answer 3 · answered Jan 07 '10 at 21:11

1

You have to have access to the Hibernate Configuration object.

answered Jan 07 '10 at 21:11

Jherico

28,584
8
61
87

score 1 · Answer 4 · answered May 16 '11 at 09:11

This will retrieve one-level composites and normal property mappings:

String columnName(String name) {
    PersistentClass mapping = configuration.getClassMapping(ExtendedPerson.class.getName());
    Property property = mapping.getProperty(name);
    if(property.isComposite()){
        Component comp = (Component) property.getValue();
        property = comp.getProperty(StringHelper.unroot(name));
        assert ! property.isComposite(); //go only one level down 
    }
    Iterator<?> columnIterator = property.getColumnIterator();
    Column col = (Column) columnIterator.next();
    assert ! columnIterator.hasNext();
    return col.getName();
}

Get column name of property mapped with Hibernate

4 Answers4

Linked