private LocalDateTime date = LocalDateTime.now();
public LocalDateTime getDate() {
return date;
}
Maven dependency
org.hibernate
hibernate-core
5.0.1.Final
org.hibernate
hibernate-java8
5.0.1.Final
Nevertheless, Hibernate still stores the LocalDateTime object as a tinyblob. What am I missing? I am using MySQL 5.6.19
According to this
Hibernate Issue, the hibernate-java8 module should map it to TIMESTAMP. I tried to put a @Column(columnDefinition=“TIMESTAMP”) on the getter, But this will cause DataIntegrityViolationException.
Put @Type(type=“org.hibernate.type.LocalDateTimeType”) on the getter. The database table remains as tinyblob.
> Hibernate version is 5.2.10.Final
>Not recommended Using hibernate-java8, all functions are included in hibernate-core
Hibernate provides type converters for all JDK date/time types:
>The OffsetDateTime getter on the entity should use @ Type annotation (type = “org.hibernate.type.OffsetDateTimeType”)
>LocalDateTime getter on the entity should use @Type annotation (type = “org.hibernate.type.LocalDateTimeType”)
… Wait.
I have switched to Java 8 and Hibernate 5 to overcome the problem of not being able to store milliseconds in Hibernate.
p>
private LocalDateTime date = LocalDateTime.now();
public LocalDateTime getDate() {
return date;
}
Maven dependency
org.hibernate
hibernate-core
5.0.1.Final
org.hibernate
hibernate-java8
5.0.1.Final
Nevertheless, Hibernate Still storing the LocalDateTime object as a tinyblob. What am I missing? I am using MySQL 5.6.19
According to this
Hibernate Issue, the hibernate-java8 module should map it to TIMESTAMP. I tried to put a @Column(columnDefinition=“TIMESTAMP”) on the getter, But this will cause DataIntegrityViolationException.
Put @Type(type=“org.hibernate.type.LocalDateTimeType”) on the getter. The database table remains tinyblob.
As of this comment:
> Hibernate version is 5.2.10.Final
>It is not recommended to use hibernate-java8, all functions are included in hibernate- In core
Hibernate provides type converters for all JDK date/time types:
>The OffsetDateTime getter on the entity should use the @Type annotation (type = “org.hibernate.type. OffsetDateTimeType”)
>The LocalDateTime getter on the entity should use @Type annotation (type = “org.hibernate.type.LocalDateTimeType”)
…etc.
< p>