Hi there.

I am trying to audit changes. I am using an Interceptor and Hibernate version 3.2. The onFlushDirty event fires fine and my insert into the table history (saving another history bean with old and new values) works too.

The only problem is I would like to know WHO makes these changes so I will have to log the user. But the user is not the same that connects to the database, because all database connects are made with one and the same user.

I am saving my user after login in the HttpSession. But how can I get this user entity in an interceptor? :(

getUserPrincipal on the HttpRequest object will tell you who logged into the web app and made the change. If this isn't the user making the database connection, which obviously it is not, you're going to have to explicitly pass this to the back end by injecting a variable into an HQL query, or writing to a log file directly.

Basically, you've got to explicitly pass this information to the back end.