Hi,

I have a scenario where I need to log complete SQL statements for audit purposes. I need to pack them with some additional information about the user.

I could turn the default hibernate logging on and this produces the SQL statements, but I need to pack additional information.

Is there a way I could get the complete SQL (insert/update/delete) in Interceptors or Events?

Even if I override the 'EntityPersister' I don't get the SQL, only the attributes and its values.

Where/How can I get the complete hibernate generated SQL, other than the log files. i.e. to manipulate programatically.

Any info is appreciated.

Thanks,
Mel

I would suggest that you need to readup on log4j (you can write your own log writer classes to log whatever information you like), except that (from experience) I have to discourage reliance upon log files for auditing purposes. if you have a requirement for auditing write it, properly... just don't forget to charge for it.