java如何使用@ManyToMany审核@JoinTable

Question

我正在做一个带有H2数据库的Spring启动项目。我有两个实体Portfolio和Report，这两个实体之间存在多对多的关联。 我希望对这些实体进行审计，因此我跟随this tutorial通过带有自定义字段的AuditorAware接口进行审计

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

投资组合。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
}

报告。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
}

可审核。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");
    }
}

持久性配置。java

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

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

Answer 1

问题：

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

解决方案：

在这里，您应该使保持Portfolio和Report之间的多对多关系的联接表显式化，以便您的程序中可以有类似PortfolioReport的实体，可以从Auditable扩展。请阅读下面的帖子了解如何做到这一点：The best way to map a many-to-many association with extra columns when using JPA and Hibernate