How to use JodaTime Instant (timestamp) with Hibernate 4.x (via Jadira usertype)?

Question

I have a timestamp(0) without time zone column in Postgres and want to map it to a Joda-Time Instant via Hibernate 4.2.2. The Joda-Time site refers to the Jadira UserType library for Hibernate versions 4.x. But there is no documentation.

Can somebody please give me an example of a timestamp Entity property used with Hibernate 4.x, preferable JPA compatible? Is there a possibility to define the mapping once so that I do not need to annotate each timestamp property with a very long class name?

I do not care about timezones. I only persist unix timestamps to the database. Timezones are handled by the View layer.

[link](java.dzone.com/articles/how-map-dates-hibernate-%E2%80%93-use DZone: How to Map Dates with Hibernate – Use joda-time) — Thomas Koch
– Thomas Koch, Commented Oct 6, 2013 at 8:10

Chris Pheby · Accepted Answer · 2013-08-15 16:15:28Z

Thomas, as a Starting Point visit this page in the documentation: http://jadira.sourceforge.net/usertype-userguide.html

This is the example there:

@Column @Type(type="org.jadira.usertype.dateandtime.joda.PersistentLocalDateTime") private LocalDateTime dateTime;

Actually that is pretty much all you need to do.

You probably want the PersistentTimestamp class (refer to the Javadoc at http://jadira.sourceforge.net/apidocs/index.html for the full list of classes). The available persistent classes for Joda Time are:

PersistentDateMidnight
PersistentDateMidnightAsString
PersistentDateTime
PersistentDateTimeAndZone
PersistentDateTimeAndZoneWithOffset
PersistentDateTimeAsString
PersistentDateTimeWithZone
PersistentDateTimeZoneAsString
PersistentDateTimeZoneWithOffsetAsString
PersistentDurationAsString
PersistentInstantAsMillisLong
PersistentInstantAsNanosBigInteger
PersistentInstantAsString
PersistentInstantAsTimestamp
PersistentInterval
PersistentLocalDate
PersistentLocalDateAsString
PersistentLocalDateTime
PersistentLocalDateTimeAsString
PersistentLocalTime
PersistentLocalTimeAsMillisInteger
PersistentLocalTimeAsNanosLong
PersistentLocalTimeAsString
PersistentLocalTimeAsTimestamp
PersistentMinutes
PersistentMonthDayAsString
PersistentPeriodAsString
PersistentTimeOfDay
PersistentTimeOfDayAsMillisInteger
PersistentTimeOfDayAsNanosLong
PersistentTimeOfDayAsString
PersistentTimeOfDayAsTimestamp
PersistentYearMonthAsString
PersistentYearMonthDay
PersistentYearMonthDayAsString
PersistentYears

I think you want PersistentInstantAsTimestamp if you are not interested in timezones, or maybe PersistentLocalDateTime.

If have any issues above and beyond this you can follow up here or report them via http://jadira.atlassian.net/ and I will do my best to assist.

Disclaimer: I am the maintainer of Jadira Usertype.

thank you for this jar. I think this list would be interesting to write on web reference. Although I found it on google after several questions I guess this info are useful in the main reference.

Collectives™ on Stack Overflow

How to use JodaTime Instant (timestamp) with Hibernate 4.x (via Jadira usertype)?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related