英文:
@Createdby @CreatedDate are null after entity is updated
问题
我已在Spring应用程序中实现了审计列，在创建新实体时它是有效的，列会被设置，但是在更新实体时，我发现两个@Createdby和@CreatedDate被设置为null，我该如何在创建后使这些列不可更改：
@MappedSuperclasspublic abstract class Audit implements Serializable {@CreatedByprivate String createdBy;@CreatedDateprivate Date createdDate;@LastModifiedByprivate String lastModifiedBy;@LastModifiedDateprivate Date lastModifiedDate;}
英文:
I've implemented auditing columns in a Spring app, and it works when i create a new entity the columns are set, but when i update the entity i find the two @Createdby and @CreatedDate are set to null, how can i make these columns unchangeable after creation :
@MappedSuperclasspublic abstract class Audit implements Serializable {@CreatedByprivate String createdBy;@CreatedDateprivate Date createdDate;@LastModifiedByprivate String lastModifiedBy;@LastModifiedDateprivate Date lastModifiedDate;}
答案1
得分: 5
对我而言，这是有效的：
@MappedSuperclasspublic class Auditor {@Column(name = "created_date", updatable = false)@CreatedDateprivate long createdDate;@Column(name = "modified_date")@LastModifiedDateprivate long modifiedDate;@Column(name = "created_by", updatable = false)@CreatedByprivate String createdBy;@Column(name = "modified_by")@LastModifiedByprivate String modifiedBy;}
然后扩展该类：
@Entity@EntityListeners(AuditingEntityListener.class)public class Material extends Auditor {@Id@SequenceGenerator(name = "seq_material", sequenceName = "seq_material")@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seq_material")private Long id;@Column@NotBlank(message = "Nome é um campo obrigatório!", groups = validacaoProd.class)private String nome;// 更多内容...}
之后我在数据库中更新了记录：
update material set created_date = 1618418750189, modified_date = 1618418750189
英文:
For me it worked:
@MappedSuperclasspublic class Auditor {@Column(name = "created_date", updatable = false)@CreatedDateprivate long createdDate;@Column(name = "modified_date")@LastModifiedDateprivate long modifiedDate;@Column(name = "created_by", updatable = false)@CreatedByprivate String createdBy;@Column(name = "modified_by")@LastModifiedByprivate String modifiedBy;}
And extending the Class:
@Entity@EntityListeners(AuditingEntityListener.class)public class Material extends Auditor {@Id@SequenceGenerator(name = "seq_material", sequenceName = "seq_material")@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seq_material")private Long id;@Column@NotBlank(message = "Nome é um campo obrigatório!.", groups = validacaoProd.class)private String nome;More...}
And I updated the records in the database :
update material set created_date = 1618418750189, modified_date = 1618418750189
答案2
得分: 0
你可以在类级别使用 @DynamicUpdate。它只会考虑更新列，忽略其他列放入更新查询中。
参考链接：https://www.baeldung.com/spring-data-jpa-dynamicupdate
英文:
you can use @DynamicUpdate in class-level. It will consider only update columns and ignore others to put in UPDATE query.
Ref : https://www.baeldung.com/spring-data-jpa-dynamicupdate
答案3
得分: 0
@Configuration@EnableJpaRepositories({"uz.dam.userservice.repositories"})@EnableJpaAuditing(auditorAwareRef = "springSecurityAuditorAware")@EnableTransactionManagementpublic class DatabaseConfiguration {}this is configuration for Jpa AuditingEntityListener class
英文:
@Configuration@EnableJpaRepositories({"uz.dam.userservice.repositories"})@EnableJpaAuditing(auditorAwareRef = "springSecurityAuditorAware")@EnableTransactionManagementpublic class DatabaseConfiguration {}
this is configuration for Jpa AuditingEntityListener class
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论