How to obtain revision number of current transaction

[scatudal]

Let's start from the fact that a new revision info is inserted for each transaction concerning audited entities.

I'm running a task that changes data in the DB and I'd like to attach the REV that corresponds to the revision at which the job was done. This way, if ever that job has to be undone, I'll have the exact revision number.

So here is the business situation:

I am processing the merge of two patient medical records. Since sometimes those merges are wrong, they may need to be undone. Having the exact revision number that matches the transaction would be more reliable than a date and time because two merges could be processed at the same time.

Thanks for your help

[adamw]

Hello,

this was introduced in Envers 1.2.1: http://www.warski.org/blog/?p=96

Adam

[scatudal]

Sorry to have bothered you, found it. On the AuditReader, there is a method named getCurrentRevision(). I had seen this method, but what threw me off is the fact that you need to specify the class you use for your revision info.


The following will get you the current revision to which any entries in the audit tables will be bound:

RevisionEntry revision = AuditReaderFactory.get( entityManager )
 .getCurrentRevision( RevisionEntry.class, true );