In my cuurnet project, I have a need to log information whenever a column is updated (for auditing purposes). So for a given object and a property, I need to log the TableName, ColumnName, OldValue, NewValue.

I am experimenting with the MetaData API and EntityPersister class to get the Table Name and ColumnName. While I could easily get the TableName using EntityPersister.getTableName(), the EnityPersister.getProperyColumnNames(int i) gives the alias names of the column and not the actual column. I see another method getActualPropertyColumnNames() that may do the job, but it is a protected method. What should I do to get the Column Name of a given property?

Also, is a there a commonly used way or a pattern to capture the new and old value and log it (or even persist it in some kind of audit table)?

It is important for me, too
Can I get table name,column name, column properties (java type, database type, length, not null etc) from persistent class and mapping ?

regards
Haris Peco

ClassMetaData and Configuration has this kind of info

How I can get instance Configuration class with spring ?
(spring's HiberanteDaoSupport have protected sessionFactory too, but I can
create new method for SessionFactory and then getClassMetadata)

Thanks

I find Configuration in spring (ctx.getBean("&sessionFactory") ), but I want
database properties from DatabaseMetadata (special decimal and precision for number field) - Can I get it from hibernate ?

regards

if you want DatabaseMetaData then fetch it from session.connection()