JodaTime Map

[Alesandro Lang]

Hello,

I want to save a java.util.Map to the Database with JPA. The Key Object is from org.joda.time.LocalDate the Value Object is an Integer. I tried a lot of stuff with the help of JodaTime-Hibernate.

e.G.

@CollectionOfElements(targetElement = Integer.class)
@MapKeyTemporal(TemporalType.TIMESTAMP)
@Type(type="org.joda.time.contrib.hibernate.PersistentLocalDate")
public Map<LocalDate, Integer>

It would be great if there is a solution which is not hibernate specific.

[Alesandro Lang]

@CollectionOfElements is deprecated now Iam using @ElementCollection

@ElementCollection(targetClass = Integer.class)
@MapKeyType(value =
@Type(type = "org.joda.time.contrib.hibernate.PersistentLocalDate"))

-> org.hibernate.MappingException: collection index mapping has wrong number of columns

[Alesandro Lang]

My workaround at the end of the day was to save java.util.Date and convert it to LocalDate .
I uses the @PrePersist and @PostLoad Annotations for this.