我有以下实体,它反映了某种后台任务,并将被更新。我认为使用JPA审计会很有用,所以我把它包括在内,如下所示:
@Entity
@RequiredArgsConstructor
@Getter
@Setter
@Table(name = "FOO")
public class FooJob{
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "ID", unique = true, nullable = false)
private long id;
@LastModifiedDate
@Column(name = "FINISHED", nullable = false)
private LocalDateTime finished;
...
}
@Repository
public interface FooJobRepository
extends JpaRepository<FooJob, Long>,
JpaSpecificationExecutor<FooJob> {}
并且我已经在弹簧引导应用程序上启用了@EnableJpaAuditing
春季版:
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.5.0</version>
<relativePath />
</parent>
但是当运行这样的代码时:
@Service
@Transactional
/*package*/ class FooJobService{
public void run() {
FooJob job = createJob();
....
}
private FooJob createJob(){
FooJob job = new FooJob();
job.setSomeValue("123");
//Do not set "finished" date here
repo.saveAndFlush(job); //THIS LINE THROWS EXCEPTION
}
}
我会得到以下异常:
org.springframework.dao.DataIntegrityViolationException:不为null属性引用了null或瞬态值:my.package.entity.FooJob.finished;嵌套异常为org.hibernate.PropertyValueException:非null属性引用null或瞬态值:my.package.entity.FooJob.finished
为什么这不起作用?
如果只更新完成日期,请将其添加到实体中:
@EntityListeners(AuditingEntityListener.class)
您需要在主类或配置类(具有@Configuration
的类(中注释@EnableJpaAuditing
并且必须用CCD_ 4来注释Entity类。
您需要向实体添加更多注释,以便对其进行审计(至少是@Audited
、@AuditTable
和@EntityListeners
。
示例:
@Entity
@Table(name = "my_table")
@AuditTable("my_table_audit")
@Audited
@EntityListeners(AuditingEntityListener.class)
public class MyEntity{
@Column(name = "created_date", nullable = false)
@CreatedDate
private Date createdDate;
@Column(name = "modified_date")
@LastModifiedDate
private Date modifiedDate;
@Column(name = "created_by")
@CreatedBy
private String createdBy;
@Column(name = "modified_by")
@LastModifiedBy
private String modifiedBy;
@Version
private Long version;
此外,我不确定@LastModifiedDate
是否可以与类型LocalDateTime
一起使用。
您还需要一个审计框架,如Hibernate Envers。
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-envers</artifactId>
</dependency>
如果您使用的是HibernateEnvers和MySQL,审计应该是这样的:
CREATE TABLE revinfo
(
revision_number integer AUTO_INCREMENT,
REVTSTMP bigint,
CONSTRAINT revinfo_pkey PRIMARY KEY (revision_number)
);
CREATE TABLE IF NOT EXISTS my_table
(
...
created_date datetime DEFAULT now(),
modified_date datetime DEFAULT now(),
created_by VARCHAR(100) NULL,
modified_by VARCHAR(100) NULL,
version INT NULL
);
CREATE TABLE IF NOT EXISTS my_table_audit
(
...
created_date datetime,
modified_date datetime,
created_by VARCHAR(100),
modified_by VARCHAR(100),
version INT,
revision_number integer,
revision_type smallint,
FOREIGN KEY fk_my_table_audit_rev_num (revision_number) REFERENCES REVINFO (revision_number)
);