[FIXED] How to map MySQL Timestamp field in Spring JAVA(JPA/Hibernate)

Issue

I am having trouble finding how to map different type of fields for different DBs in a Spring Boot Application. Primarily, I would like to know how to map the MySQL Timestamp but it would be great if I can also find a link to the collection of mappings for every datatype in different DBs.

Solution

The list of standard basic types you can find here.

1. You can map TIMESTAMP to the following Java 8 types:

java.time.Instant, java.time.LocalDateTime, java.time.OffsetDateTime and java.time.ZonedDateTime.

2. You can also use outdated java.util.Date (see this):

@Column(name = "`timestamp`")
@Temporal(TemporalType.TIMESTAMP)
private Date timestamp;

But the first approach is much more preferable.

Answered By - SternK