@CreatedBy and @LastModifiedDate are no longer working with ZonedDateTime?

Question

i have updated an old spring boot 1.5.3 project to spring boot 2.0.0. RELEASE. I have an auditing entity with two fields of type ZonedDateTime annotated with @CreatedBy and @LastModifiedDate.

In the previous versions everything was working fine. However, with the new update, upon saving the entity in the repository i get an error i.e

 createdDate=<null>
 lastModifiedDate=<null>
 ]! Supported types are [org.joda.time.DateTime, org.joda.time.LocalDateTime, java.util.Date, java.lang.Long, long]

I checked the AnnotationAuditingMetaData, and i found noting related to ZonedDateTime.

There is also this issue in https://jira.spring.io/browse/DATAJPA-1242, I believe it's related.

My question is what am i doing wrong here, does spring stopped the support or am i doing something wrong?

score 35 · Answer 1 · answered Sep 02 '19 at 13:22

I had the same problem and could solve it adding a dateTimeProviderRef to @EnableJpaAuditing.

Java

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.auditing.DateTimeProvider;
import org.springframework.data.jpa.repository.config.EnableJpaAuditing;
import java.time.ZonedDateTime;
import java.util.Optional;

@Configuration
@EnableJpaAuditing(dateTimeProviderRef = "auditingDateTimeProvider")
public class PersistenceConfig {

    @Bean // Makes ZonedDateTime compatible with auditing fields
    public DateTimeProvider auditingDateTimeProvider() {
        return () -> Optional.of(ZonedDateTime.now());
    }

}

Kotlin

@Configuration
@EnableJpaAuditing(dateTimeProviderRef = "auditingDateTimeProvider")
class PersistenceConfig {

    @Bean // Makes ZonedDateTime compatible with auditing fields
    fun auditingDateTimeProvider()= DateTimeProvider { of(ZonedDateTime.now()) }

}

Facing this error : org.bson.codecs.configuration.CodecConfigurationException: Can't find a codec for class java.time.ZonedDateTime. Did you face the same issue? I'm with Java, MongoDB. — Nguyễn Đức Tâm, Aug 17 '21 at 17:17
@NguyễnĐứcTâm You also need to register the converters for ZonedDateTime, like here: https://stackoverflow.com/a/51664363/4245733 — Indivon, Aug 18 '21 at 09:50

luboskrnac · Accepted Answer · 2021-04-14T09:53:26.703

0

Old answer was mistaken, but I can't delete it because it is accepted. Please scroll to other answers.

edited Apr 14 '21 at 09:53

answered Mar 08 '18 at 10:22

luboskrnac

23,973
10
81
92

2

It' doens't work for me. Is there any other solutions? – Erlan Sep 17 '18 at 12:49
1

jackson has nothing to do with JPA – Adam from WALCZAK.IT May 04 '20 at 16:06

score 0 · Answer 3 · answered Jan 31 '23 at 08:34

0

You also have to put this annotation @EntityListeners(AuditingEntityListener.class) on the class where you use the @CreatedDate.

answered Jan 31 '23 at 08:34

Bunyi

1

@CreatedBy and @LastModifiedDate are no longer working with ZonedDateTime?

3 Answers3