[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3939) @NotAudited association requires and joins to the associated table

[dsailer (JIRA)]

@NotAudited association requires and joins to the associated table
------------------------------------------------------------------

                 Key: HHH-3939
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3939
             Project: Hibernate Core
          Issue Type: Bug
          Components: envers
         Environment: envers-1.2.0
hibernate-3.3.1.ga
hibernate-annotations-3.4.0.ga
postgresql-8.1-407
            Reporter: dsailer


We have an Asset with an association to an Organization. Asset is audited and Organization is not. The association to Organization has @NotAudited. However, envers still requires the join table to exist. If the table exists AuditReader's queries for Asset revisions try to join to that table. Our work around was to go ahead and audit Organization. Here is the code:

@Entity
@Table(name = "MTE_ASSET")
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@Audited
public class Asset extends AuditableEntity implements Serializable{
<snip>
   @ManyToOne
   @JoinTable(name="mte_organization_mte_asset",
              joinColumns = @JoinColumn(name="asset_id"),
              inverseJoinColumns = @JoinColumn(name="organization_id"))
   private Organization organization;
<snip>
}


@Entity
@Table(name = "MTE_ORGANIZATION")
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(
   name = "organization_type",
   discriminatorType = DiscriminatorType.STRING
)
@DiscriminatorValue("Organization")
public class Organization extends AuditableEntity {
<snip>
   @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
   @JoinTable(name = "mte_organization_mte_asset", joinColumns = @JoinColumn(name = "organization_id"), inverseJoinColumns = @JoinColumn(name = "asset_id"))
   @OrderBy(value="name asc")
   private List<Asset> assets = new ArrayList<Asset>();
<snip>
}


without the table mte_organization_mte_asset_audit defined and using:
<entry key="hibernate.hbm2ddl.auto" value="validate"/>

we get:

Caused by: org.hibernate.HibernateException: Missing table: mte_organization_mte_asset_audit
        at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1113)
        at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)
        at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:349)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327)
        at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.jav
a:867)
        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)

... 38 more

If we create the table mte_organization_mte_asset_audit but don't audit Organization the queries from AuditReader include a join to  mte_organization_mte_asset_audit and we get no rows back. 

-- 
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