@CreatedDate annotation does not work with mysql

Question

I am new to spring and I am confused how @CreatedDate annotation works in an entity.

I did a google search and there were many solutions, but none of them worked for me except one. I am confused why?

This is what I tried first

@Entity
@EntityListeners(AuditingEntityListener.class)
public class User implements Serializable {

    @Id
    @GeneratedValue
    private Long id;
    private String name;

    @CreatedDate
    private Date created;

    public User(String name) {

        this.name = name;
    }

    public User() {
    }

It did not work. I got NULL for the value in created column.

Then I did this.

@Entity
@EntityListeners(AuditingEntityListener.class)
public class User implements Serializable {

    @Id
    @GeneratedValue
    private Long id;
    private String name;

    @CreatedDate
    private Date created = new Date();

    public User(String name) {

        this.name = name;
    }

    public User() {
    }

This actually stored the time stamp in the db. My question is most of the tutorials I followed suggested that I do not need new Date() to get the current time stamp. Looks like I do need that. Is there anything I am missing?

Novikoff

Did you try this ? #20484341 – Maldives

Actually, I don't think assigning a new Date() makes annotation work. It simply creates a date instance when your entity is initialized. For SpringBoot Adding @EnableJpaAuditing in your SpringBoot application main class will make those annotations work – Kilowatt

Answer 1

The @CreatedDate won't work by itself if you just put @EntityListeners(AuditingEntityListener.class) on your entities. In order, it'll work you have to do a little more configuration.

Let's say that in your DB the field of @CreatedDate is String type, and you want to return the user that is currently logged in as a value for @CreatedDate, then do this:

public class CustomAuditorAware implements AuditorAware<String> {

    @Override
    public String getCurrentAuditor() {
        String loggedName = SecurityContextHolder.getContext().getAuthentication().getName();
        return loggedName;
    }

}

You can write there any functionality that fits your needs, but you certainly must have a bean that reference to a class that implements `AuditorAware

The second part and equally important, is to create a bean that returns that class with annotation of @EnableJpaAuditing, like this:

@Configuration
@EnableJpaAuditing
public class AuditorConfig {

    @Bean
    public CustomAuditorAware auditorProvider(){
        return new CustomAuditorAware();
    }
}

if your poison is XML configuration then do this:

<bean id="customAuditorAware" class="org.moshe.arad.general.CustomAuditorAware" />
    <jpa:auditing auditor-aware-ref="customAuditorAware"/>

Dodeca

I have the same config, but this sets values to @CreatedBy and @LastModifiedBy annotated field. Other fields that annotated as @LastModifiedDate and @CreatedDate is always null. How to fix this? – Moorish

Did you try what it says here: https://mcmap.net/q/324458/-simple-spring-createddate-annotation-is-not-working-for-me – Uncouple

for me it was required to pass AuditorAware ref even while using annotations: @EnableJpaAuditing(auditorAwareRef = "auditorProvider") where auditorProvider - @Bean function providing the AuditorAware instance – Romelda

Answer 2

I was Having this issue also and your solution helped me, Thanks, And I add some other annotations to work

Fist make sure you put in SpringApplication Configuration

@SpringBootApplication
@EnableJpaAuditing

Second, make sure you use this annotation on your needed entities

  @Entity
  @Table
  @EntityListeners(AuditingEntityListener.class)

Thematic

Thank you , this helped me resolve the @CreatedDate annotation not working. It is not advisable to use this annotation along with @SpringBootApplication . I had the following error while testing : java.lang.IllegalArgumentException: JPA metamodel must not be empty! . Please read through this answer as well . One should make sure the unrelated slices wont interfere while testing as well. – Phalarope

Great. It works – Drilling

Answer 3

You can use @CreationTimestamp and @UpdateTimestamp like this:

  @CreationTimestamp
  private Instant createdAt;

  @UpdateTimestamp
  private Instant updatedAt;

Primm

Answer 4

If you want to use java8 time classes:

@EnableJpaAuditing(dateTimeProviderRef = "auditingDateTimeProvider")
....

@Bean(name = "auditingDateTimeProvider")
public DateTimeProvider dateTimeProvider() {
        return () -> Optional.of(OffsetDateTime.now());
}

Sonometer

Answer 5

Without using JPA Entity listener, create date will not work as this is how JPA work for auditing and create or modify date.

just modify code like below:

@Entity
@EntityListeners(AuditingEntityListener.class)
class XYZ {

    @Setter(value = AccessLevel.NONE)
    @CreatedDate
    @Column(name = "date_time")
    private Date dateTime;


}

Involuted

Answer 6

Add @EnableMongoAuditing or @EnableJpaAuditing as per your code

Annamaeannamaria

someone else already mentioned @EnableJpaAuditing – Taxation