0 Replies Latest reply on Nov 21, 2014 8:43 PM by Guillermo L

    Fail to create FK to revinfo table for each schema

    Guillermo L Newbie

      Hi,

      I'm trying to integrate envers (4.2.3) within my application but I'm having some issues :-(. The database engine is an MS SQL Server 2008 and I've segregated tables using schemas so I have something like the following:

       

      testdb:

         schema1.table1

         schema1.table2

         schema2.table3

       

      I've annotated my entities with @Audited, I've defined a custom revision entity (within the default DBO schema) and have hibernate to create db objects automatically (schema update). So far so good however when I start the application I can see that hibernate tries to create the audited tables pointing to a revision entity (revinfo) within each schema (schema1.table1 pointing to schema1.revinfo, schema2.table2 pointing to schema2.revinfo) and fails to do so (FK creation) since just one revinfo table within DBO schema has been created (dbo.revinfo).

       

      Is there anyone out there who can tell me what I'm doing wrong here?

       

      Thanks in advance for your help!!!