Populate envers revision tables with existing data from Hibernate Entities

java hibernate hibernate-envers
danieljimenez picture danieljimenez · May 22, 2009 · Viewed 11.7k times · Source

I'm adding envers to an existing hibernate entities. Everything is working smoothly so far as far as auditing, however querying is a different issue because the revision tables aren’t populated with the existing data. Has anyone else already solved this issue? Maybe you’ve found some way to populate the revision tables with the existing table? Just thought I’d ask, I'm sure others would find it useful.

Answer

deryl picture deryl · Dec 1, 2011

We populated the initial data by running a series of raw SQL queries to simulate "inserting" all the existing entities as if they had just been created at the same time. For example:

insert into REVINFO(REV,REVTSTMP) values (1,1322687394907); 
-- this is the initial revision, with an arbitrary timestamp

insert into item_AUD(REV,REVTYPE,id,col1,col1) select 1,0,id,col1,col2 from item; 
-- this copies the relevant row data from the entity table to the audit table

Note that the REVTYPE value is 0 to indicate an insert (as opposed to a modification).

Related questions

What's the difference between @NotAudited and RelationTargetAuditMode.NOT_AUDITED in Hibernate EnVers?

@NotAudited @Audited(targetAuditMode = RelationTargetAuditMode.NOT_AUDITED) @OneToMany(mappedBy = "booking") @OrderBy("bookingOrder") private List<CustomerBooking> customerBookingList = new LinkedList<CustomerBooking>(); Why use both? is it good to use both or would one suffice?

Read More
How not to audit a join table and related entities using Hibernate Envers?

I use Hibernate Envers to audit my entities. I have one audited entity, Foo, which has a List<Bar> as properties. However, I don't want to audit the Bar entities. Thus, I wrote that: @Entity @Audited public class …

Read More
Get previous version of entity in Hibernate Envers

I have an entity loaded by Hibernate (via EntityManager): User u = em.load(User.class, id) This class is audited by Hibernate Envers. How can I load the previous version of a User entity?

Read More