为什么Hibernate Envers将Last_edited_by列值替换为“ API”

Question

我有类似的类结构：

@Entity
@Data
@Table(name="person_dtl")
@Audited
@AuditTable(value="h$person_dtl")
public class Person extends AuditBaseEntity implements Serializable {

     @Id
      @Column(name="person_ID", nullable = false)
      private String personID;
      
      @Column(name="person_Name", nullable = false)
      private String personName;

}

@Audited
@MappedSuperClass
@EntityListeners(AuditingEntityListener.class)
public abstract class AuditBaseEntity extends BaseEntity {
    
    
    @Column(name = "created_by", nullable = false, updatable = false)
    @CreatedBy
    protected String createdBy;

    @Column(name = "last_modified_by")
    @LastModifiedBy
    private String lastModifiedBy;
    
    @Column(name = "created_date", nullable = false, updatable = false)
    @CreatedDate
    protected Date createdDate;

    @Column(name = "last_modified_date")
    @LastModifiedDate
    private Date lastModifiedDate;
    
    @PrePersist
    public void onPrePersist() {
        this.activeIndicator="A";
    }
     
    @PreRemove
    public void onPreRemove() {
        this.activeIndicator="I";
    }
}

@Audited
@MappedSuperClass
public abstract class BaseEntity {
    
    @Column(name = "active_ind", nullable = false)
    @CreatedBy
    protected String activeIndicator;
}

我一直在使用Hibernate Envers在Spring-Boot应用程序中进行审计。我在pom中包括了spring-data-jpa和envers依赖性。我明确设置了createby和lastModifiedby列的值，但是每当发生插入发生createby and code> lastModifiedby 时列值在我们的Oracle DB中的表中设置为“ API”。同样，每当我执行更新lastModifiedby列值时，即使我将用户ID设置在实体中，也将设置为“ API”。为什么会发生这种情况？我是否缺少某些财产价值？

Answer 1

由于您使用的是弹簧数据，因此用@createdby @lastmodifiedby注释的实体将被当前记录的用户填充。
您可以覆盖此行为，并告诉Spring在数据库中插入新记录时存储当前的用户ID。为此，您将需要提供auditoraware接口和Override getCurrentAuditor（）方法的实现。内部getCurrentAuditor（）您需要获取当前登录用户的ID。

 @Component
    public class SpringSecurityAuditorAware implements AuditorAware<String> {
    
        @Override
        public String getCurrentAuditor() {
           Authentication authentication = SecurityContextHolder.getContext().getAuthentication();
MyUserDetails customUser = (MyUserDetails)authentication.getPrincipal();
int userId = customUser.getUserId();
     return String.valueOf(userId);
        }
    }