Create DATETIME in MariaDB using LocalDateTime column type in JPA

Question

I need create DATETIME column in MariaDB using LocalDateTime column type in JPA.

I created this entity:

@Column
private LocalDateTime created_at;

but when I depot the code the column in MariDB is updated to DATE. I need DATETIME.

I also tried this:

@Column
@Temporal(TemporalType.TIMESTAMP)
private LocalDateTime created_at;

But when I deploy the code I get error:

@Temporal should only be set on a java.util.Date or java.util.Calendar property

I use Java 10 and spring-boot-starter-parent

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.5.RELEASE</version>
        <relativePath />
    </parent>

Is there any solution to this problem? For example is there a way to set the column type into the entity as DATETIME without using @Temporal?

Are you sure you used LocalDateTime in your try without @Temporal because LocalDateTime should be DATETIME in the db. When I tried it with spring-boot-starter-parent, it worked. — Tom, Oct 08 '18 at 10:02

user987339 · Accepted Answer · 2018-10-09T08:47:45.723

4

If you want to store a LocalDateTime in a TIMESTAMP column, you need to implement the mapping to java.sql.Timestamp.

You need to implement the AttributeConverter interface.

@Converter(autoApply = true)
public class LocalDateTimeAttributeConverter implements AttributeConverter<LocalDateTime, Timestamp> {

    @Override
    public Timestamp convertToDatabaseColumn(LocalDateTime locDateTime) {
        return (locDateTime == null ? null : Timestamp.valueOf(locDateTime));
    }

    @Override
    public LocalDateTime convertToEntityAttribute(Timestamp sqlTimestamp) {
        return (sqlTimestamp == null ? null : sqlTimestamp.toLocalDateTime());
    }
}

edited Oct 09 '18 at 08:47

answered Oct 06 '18 at 10:34

user987339

10,519
8
40
45

1

I tried the above code but during deployment I get again @Temporal should only be set on a java.util.Date or java.util.Calendar property – Peter Penzov Oct 06 '18 at 10:58
You should define attribute without @Temporal. – user987339 Oct 06 '18 at 11:03
So just keep @Column – user987339 Oct 06 '18 at 11:03
I tried but this creates DATE column in MariaDB. I need DATETIME column – Peter Penzov Oct 06 '18 at 11:07
1

The JPA persistence unit needs to know about the converters. This can be done by adding the converters to the persistence.xml. – user987339 Oct 06 '18 at 11:18
I added @Convert(converter = LocalDateTimeConverter.class) before the column declaration but during deployment I get the exception. – Peter Penzov Oct 06 '18 at 11:28
what exception? – user987339 Oct 06 '18 at 11:36
@Temporal should only be set on a java.util.Date or java.util.Calendar property – Peter Penzov Oct 06 '18 at 12:20
1

remove @Temporal – user987339 Oct 06 '18 at 12:31

Create DATETIME in MariaDB using LocalDateTime column type in JPA

1 Answers1