delete operations inside a stored procedure.

varun14 Jun 17, 2013 5:05 AM

Hi All,

I am using Hibernate 4.1.9 final version.I have used evers to audit my data.It is working as expected.But the entity that I am auditing has insert/update/delete operations through stored procedures.

Can anyone tell me is there possiblity to keep track of data even if it is being modified through stored procedures.Also I thought of Triggers to manage this but again the question of synchronisation arises in real time when we try to generate the unique id for 'revinfo' table.

Thanks in advance.

1. Re: How to audit a table data which has add/update/delete operations inside a stored procedure.

adamw Jun 17, 2013 10:05 AM (in response to varun14)

Envers will only work if the operations are performed through Hibernate.

If you have stored procedures, you have to rely on hand-written triggers or modifying the stored procedures.

Adam
Actions
2. Re: How to audit a table data which has add/update/delete operations inside a stored procedure.

varun14 Jun 18, 2013 1:07 AM (in response to adamw)

Thanks Adam for reply.

I will look for a better solution using trigger or other which fits best.As I get it will post here for reference.
Actions
3. Re: How to audit a table data which has add/update/delete operations inside a stored procedure.

varun14 Oct 4, 2013 6:19 AM (in response to varun14)

As you said Adam, I have created my own function and called it in every procedure where the direct operations are performed on my table.
Also I have created new audit table to audit the direct insert/update/delete at database level.While displaying the audit reports the join of my audit table and envers audit table is taken.

Thank you...
Actions

Go to original post