In Spring Data JDBC bypass @CreatedDate and @LastModifiedDate

Question

I have an entity that has fields annotated with @CreatedDate and @LastModifiedDate.

However, in some cases I want to set these two fields manually.

Is there a way to bypass @CreatedDate and @LastModifiedDate in some cases without removing the annotations from the entity? Or is there a callback that I can add before the entity gets saved?

Have you checked @PrePersist and @PreUpdate? https://www.baeldung.com/jpa-entity-lifecycle-events — aksappy, May 31 '21 at 14:30
@aksappy `@Prepersist` and `@PreUpdate` are JPA annotations and have no effect on Spring Data JDBC entities. — Jens Schauder, May 31 '21 at 15:05
@aksappy I also don't want to modify the entity class if possible. The `BeforeSaveEvent` did not help unfortunately. — Harold L. Brown, May 31 '21 at 15:20

score 2 · Accepted Answer · answered May 31 '21 at 17:01

Populating the auditing information is done by the RelationalAuditingCallback and IsNewAwareAuditingHandler.

The first one basically is the adapter to the module specific part (Spring Data Relational in this case) while the second modifies the entity.

You can implement your own variant of the IsNewAwareAuditingHandler stuff it in a RelationalAuditingCallback and register it as a bean. I did something similar a short time ago in this project on GitHub:

@Bean
RelationalAuditingCallback isNewAwareAuditingHandler(JdbcMappingContext context) {
    return new RelationalAuditingCallback(new CustomAuditingHandler(context));
}

private static class CustomAuditingHandler extends IsNewAwareAuditingHandler {

    public CustomAuditingHandler(JdbcMappingContext context) {
        super(PersistentEntities.of(context));
    }

    @Override
    public Object markAudited(Object source) {

        if (!(source instanceof Product)) {
            return source;
        }

        Product product = (Product) source;
        if (product.createdDate == null) {
            product.createdDate = Instant.now();
        }

        return source;
    }
}

Please consider the logic in the CustomAuditingHandler a place holder. There you should plugin your way to determine if you set the value manually. Maybe your entity implements an interface that offers that information as a transient field, or you store that information in a thread local variable.

score 0 · Answer 2 · answered Jun 04 '21 at 06:23

if u use above solution on spring boot, it ok. but in use @EnableJdbcAuditing, u should remove @EnableJdbcAuditing. if it use that, RelationalAuditionCallback is dupulicated on ApplicationContext.

Here's a test based on @Jens Schauder's idea. https://github.com/yangwansu/try-spring-data-jdbc/blob/main/src/test/java/masil/example/springdata/jdbc/ch9_14_1/ManuallySetupTest.java

In Spring Data JDBC bypass @CreatedDate and @LastModifiedDate

2 Answers2