如何使用@ManyToMany审计@JoinTable

Question

我正在开发一个带有H2数据库的Spring项目。我有两个实体Portfolio和Report，两者之间有一个多到多的联系。我希望对这些实体进行审计，因此我遵循本教程通过带有自定义字段的AuditorAware接口进行审计。

对这两个实体进行了良好的审计，并在数据库中创建了列。但是，未对联接表portfolio_reports进行审计。如何对联接表进行审计？

Portfolio.java

@Entity
@Table(name = "portfolio")
public class Portfolio extends Auditable<String> implements Serializable {

    @Id
    @Column(name = "id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(name = "name")
    @Unique
    private String name;

    @ManyToMany(fetch = FetchType.LAZY, cascade = CascadeType.PERSIST)
    @JoinTable(name = "portfolio_report", joinColumns = @JoinColumn(name = "portfolio_id"), inverseJoinColumns = @JoinColumn(name = "report_id"))
    private List<Report> reports;
    
    // Getters and setters
}

Report.java

@Entity
@Table(name = "report")
public class Report extends Auditable<String> implements Serializable {

    @Id
    @Column(name = "id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    
    @Column(name = "axioma_id")
    private Long axiomaId;

    @Column(name = "name")
    private String name;

    @AuditJoinTable
    @ManyToMany(mappedBy = "reports", cascade = CascadeType.PERSIST, fetch = FetchType.LAZY)
    private List<Portfolio> portfolios;

    // Getters and setters
}

Auditable.java

@MappedSuperclass
@EntityListeners(AuditingEntityListener.class)
public abstract class Auditable<U> {

    @Version
    @Column(name = "version_no")
    protected Long versionNo;

    @CreatedDate
    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "created_date")
    protected Date createdDate;

    @LastModifiedDate
    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "modified_date")
    protected Date modifiedDate;

}

AuditorAwareImpl.java

public class AuditorAwareImpl implements AuditorAware<String> {

    @Override
    public Optional<String> getCurrentAuditor() {
        return Optional.of("Admin");
    }
}

PersistenceConfiguration.java

@Configuration
@EnableJpaAuditing(auditorAwareRef = "auditorAware")
public class PersistenceConfiguration {

    @Bean
    public AuditorAware<String> auditorAware() {
        return new AuditorAwareImpl();
    }
}

Answer 1

问题：

显然，在这里，Auditable应该在中间表中添加一些列，以维护Portfolio和Report之间的关系，并且该表是在场景后面创建的，并且您无法在程序中访问该表。只有hibernate可以使用该表来维护实体之间的关系并执行联接操作。

解决方案：

在这里，您应该使Join表显式地维护Portfolio和Report之间的多到多关系，这样您的程序中就可以有可以从Auditable扩展的实体，比如PortfolioReport。请阅读以下帖子以了解如何做到这一点：使用JPA和Hibernate时，使用额外列映射多到多关联的最佳方法。