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

[Mohan K (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=38424#action_38424 ] 

Mohan K commented on HHH-5482:
------------------------------

This is a bug in later versions as well (3.5.4.) Any hope of this getting resolved?

> 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
>
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> 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