I have an application in which changes are done using hibernate and plain sql (without hibernate).
For the changes done with hibernate I would like to store the current data in an audit table using envers e.g.
current data: aaaa, bbbb
new data: cccc, dddd
Now I would like that aaaa, bbbb goes the audit table and cccc, dddd to the current table.
Right now I get cccc, dddd in the audit table and the current table and there is no way I can find out what originally was in the current table.
Many thanks for your answer Maurus
Unfortunately you can't do that using Envers. What you are probably looking for is some workflow solution, where new values need to be "accepted".