Manually create an audit table for Hibernate Envers

Question

I understand Envers generates a table to store the audit trail. Is it possible to manually assign a table where I want the data to be stored. Instead of allowing Envers to generate a table by itself?

Answer 1

It will only generate the tables if you are using one of the ddl auto options.

If you want to control the naming of the audit tables during this process or, create the tables yourself and have them named differently then you specify the value for the @AuditTable annotation and/or specify the prefix and suffix in the configuration.

Additionally, you can control/specify the name of the global REVINFO table using the @RevisionEntity annotation.

http://docs.jboss.org/envers/docs/#tables

All of which is detailed in the comprehensive documentation:

http://docs.jboss.org/envers/docs/#tables