Spring Boot JPA Hibernate-以毫秒级精度存储日期

Question

Spring启动版本“2.3.4.release”
Java 11
org.springframework.Boot:spring-boot-starter-jdbc
org.springframework.Boot:spring-boot-starter-data-jpa
spring-data-jpa-2.3.4.release
运行时（mysql：mysql-connector-java）

服务器DB MariaDB（版本10.5.5-MariaDB)
Java MariaDB连接器J:2.6.0[稳定]

我试图以毫秒级的精度在Hibernate中持久化一个java.sql.Timestamp对象。我需要用毫秒保存日期到数据库。例如:2020-10-08 03:23:38.454。

我的域：

import java.sql.Timestamp;
@Entity
@Data
@Table(name = "date_test")
public class DateTestDomain {
    @Id
    @Column(nullable = false, name = "date", columnDefinition = "TIMESTAMP(3)")
    @Temporal(TIMESTAMP)
    private Calendar dateTest;
}

我的回购：

@Repository
public interface DateTestRepo extends JpaRepository<DateTestDomain, Timestamp> {
}

将日期保存到数据库：

private final JdbcTemplate db;
...
        long testTime = 1602120218454L;
        Timestamp dateTimeStamp = new Timestamp(testTime);
        db.update("INSERT INTO date_test" + " (date) VALUES( \"" + dateTimeStamp + "\")");

UPD：sql的结果是我所需要的！！！此方法工作完美：2020-10-08 03:23:38.454

        Calendar calendar = Calendar.getInstance();
        Date date = new Date();
        calendar.setTimeInMillis(date.getTime());
        dateTestDomain.setDateTest(calendar);

        dateTestRepo.save(dateTestDomain);

我尝试了sql方言:
org.hibernate.dialt.mysql5InnoDbDialogue than org.hibernate.dialt.mysql55InnoDbDialogue than org.hibernate.dialt.mariadb103Dialogue than org.hibernate.dialt.mariadb105Dialogue than org.hibernate.dialt.mariadb105Dialogue than org.hibernate.dialt.mariadb105Dialogue than org.hibernate.dialt.mariadb105Dialogue

结果SQL:
2020-10-10 15:33:29.101,2020-10-10 13:33:29.000,2020-10-10 15:33:29.000。

还有一个问题:
DB日期:
2020-10-10 16:19:42.578
2020-10-10 16:20:47.000
2020-10-10 16:20:47.888
2020-10-10 16:20:47.892
2020-10-10 16:20:47.896
2020-10-10 16:20:47.900
Hibernate:select datetestdo0_.TIMESTAMP作为timestam1_0_from date_test datetestdo0_where datetestdo0_.TIMESTAMP>？
绑定参数[1]作为

jdbcsql:
从date_test中选择时间戳，其中时间戳>“2020-10-10 16:20:47.893”
2020-10-10 16:20:47.896
2020-10-10 16:20:47.900

JPA/Hibernate无法工作毫秒...

Answer 1

由于JPA2.2支持java8日期和时间API。我没有尝试过它是否可以解决您的问题，但您是否可以尝试使用Java8的localdatetime而不是calendar类型。

替换：

@Id
@Column(nullable = false, name = "date", columnDefinition = "TIMESTAMP")
@Temporal(TIMESTAMP)
private LocalDateTime localDateTime;