4 Replies Latest reply on May 26, 2008 2:36 PM by Adam Warski

    Version groups and database space management

    Andrew Wheeler Newbie

      What a great project!

      I support the concept of "revisioning groups" for strongly connected entities as a configuration parameter. Perhaps @Versioned(group="mygroup") at the class level. I guess this would create a version info table based on the group name.

      From a database management point of view I'd like to move these audit tables to alternative storage. To use the postgresql terminology, the ability to specify schema or tablespace.

      I suggest adding a configuration element:

      <property name="org.jboss.envers.versionsTablePrefix" value="audit." />
      


      This would create an audit table:
      create table audit.person_v (
      .
      .
      .
      )
      


      This should work for other databases such as Sybase and MS SQL as the prefix would specify another database on the same server.