@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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira