@Converter(autoApply = true)
public class MyLocalDateConverter implements AttributeConverter<java.time.LocalDate, java.sql.Date> {
@Override
public java.sql.Date convertToDatabaseColumn(java.time.LocalDate attribute) {
return attribute == null ? null : java.sql.Date.valueOf(attribute);
}
@Override
public java.time.LocalDate convertToEntityAttribute(java.sql.Date dbData) {
return dbData == null ? null : dbData.toLocalDate();
}
}
Using JPA 2.1 AttributeConverter against Java8 LocalDate / LocalDateTime
TweetPosted on Tuesday Mar 17, 2015 at 01:50PM in JPA
I created an example project using https://weblogs.java.net/blog/montanajava/archive/2014/06/17/using-java-8-datetime-classes-jpa which ran on WildFly 8.2.0.Final (Hibernate 4.3.7) and H2 / Apache Derby database.
the whole project can be obtained from https://github.com/lbtc-xxx/jpa21converter .
You don’t need to define any additional configuration in persistence.xml if you use converters in EE environment. it goes like this:
The converter for LocalDate between DATE
The converter for LocalDateTime between TIMESTAMP
@Converter(autoApply = true)
public class MyLocalDateTimeConverter implements AttributeConverter<java.time.LocalDateTime, java.sql.Timestamp> {
@Override
public java.sql.Timestamp convertToDatabaseColumn(java.time.LocalDateTime attribute) {
return attribute == null ? null : java.sql.Timestamp.valueOf(attribute);
}
@Override
public java.time.LocalDateTime convertToEntityAttribute(java.sql.Timestamp dbData) {
return dbData == null ? null : dbData.toLocalDateTime();
}
}
Entity class
@Entity
public class MySimpleTable implements Serializable {
@Id
@GeneratedValue
private Long id;
private java.time.LocalDateTime someLocalDateTime;
private java.time.LocalDate someLocalDate;
...
Hibernate produces the DDL against H2 as follows:
create table MySimpleTable (
id bigint not null,
someLocalDate date,
someLocalDateTime timestamp,
primary key (id)
)
Using converters with @EmbeddedId
Converters doesn’t work with fields that annotated as @Id (see http://stackoverflow.com/questions/28337798/hibernate-fails-to-load-jpa-2-1-converter-when-loaded-with-spring-boot-and-sprin ) but works with @EmbeddedId class.
Entity class:
@Entity
public class MyCompositeKeyTable implements Serializable {
@EmbeddedId
private MyCompositeKeyEmbeddable key;
...
Embeddable class:
@Embeddable
public class MyCompositeKeyEmbeddable implements Serializable {
@Column(nullable = false)
private java.time.LocalDateTime someLocalDateTime;
@Column(nullable = false)
private java.time.LocalDate someLocalDate;
...
Produced DDL:
create table MyCompositeKeyTable (
someLocalDate date not null,
someLocalDateTime timestamp not null,
primary key (someLocalDate, someLocalDateTime)
)
Thanks Kohei for this article, I'm updating TightBlog to Java8 time right now, and your "MyLocalDateTimeConverter" now has a proud home in my project. :)
Hi Glen, I'm glad I could help. thank you for letting me know!
Can you tell me one thing, if i m using autoApply in @Convert in hibernate 4.3.1 version not working. Their is any reason?
Posted by Gourav kumar on October 18, 2018 at 10:34 PM JST #
Hi Gourav, one possibility is that if you use SE environment you need to declare the converter into persistence.xml. Like this https://stackoverflow.com/questions/27574855/registering-converters-in-jpa-2-1-with-eclipselink hope this helps
Posted by Kohei on October 19, 2018 at 07:21 AM JST #
