[hibernate-issues] [Hibernate-JIRA] Created: (HHH-5482) Enver Auditing: Audit Join table is missing columns or behaving incorrectly on a @ManyToOne mapping

[Mohan K (JIRA)]

Enver Auditing: Audit Join table is missing columns or behaving incorrectly on a @ManyToOne mapping
---------------------------------------------------------------------------------------------------

                 Key: HHH-5482
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5482
             Project: Hibernate Core
          Issue Type: Bug
          Components: envers
    Affects Versions: 3.3.2
         Environment: Hibernate: 3.3.2.GA; Envers: 1.2.2.GA; jbpm:4.1; hibernate.jpa: 3.4.0.GA
Database: MS SQL Server 2008
            Reporter: Mohan K
         Attachments: ManyToOne_Audit_Issue.zip

Trying to audit the Many table on the @ManyToOne relationship. The generated Audit Join table has REVTYPE and other columns missing.

Scenario:
We are using a join table to establish the Many to One relationship and we would like to Audit this join table for any changes.

As a test case: We have Person Table (person_id) & Address Table (address_id) and PersonAddress table (Join Table). Each Address can have 0 or more persons.

Our requirement is to Audit Person table and in turn PersonAddress join table for any mapping changes with respect to Person.

However the PersonAddress_Audit table that enver/hibernate creates seems to have person_id, REV columns only. We were expecting to see two other columns - address_id and REVTYPE.


Is this a bug or is there something that we are not doing right?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira