Does ENVERS do an audit only when the transaction is committed?

[shyenuganti]

I am having a short running BPEL where everything goes end to end in one single transaction. Inside this flow, we have several insert and update operations . We are using Hibernate to work with Database. We are getting the session from context and doing a session.flush() when required. But we cannot start a transaction and end that transaction inside this global transaction.

The problem now is the audit records are not being inserted for the insert/update operations inside the flow. Only the last update at the end of the transaction is being audited. But I can see that the listeners are being called for every update but the audit tables are not populated with audit records.

How can I make Envers to insert audit records for all the inserts/updates? Or is it that Envers only audits when the transaction is committed?

[adamw]

As long as all the inserts/updates happen in the transaction, the audit logs should be written at the end of it. So when the transaction is commited, audit entries for all the operations that happended get written. Before that, it is not possible to determine what the audit entry should be (if you change and flush the same entity several times).

Do you see some audit entries missing?

Adam

[shyenuganti]

Yes, Only the last entry is being audited !! I can see the listener being called for every insert/update but audit tables are updated only for the last update.