joda.time.DateTime with hibernate createQuery to setDate

Question

pojo

public class RateCode implements java.io.Serializable {

     private org.joda.time.DateTime travelTo;
     private org.joda.time.DateTime bookingFrom;
}

Query

Query q = session.createQuery(
                "from RateCode rr where rr.id.date>=:from and rr.id.date<=:to order by rr.id.date").setDate("from", from).setDate("to", to);

But setDate/setTimeStamp Require util.Date.

ERROR: java.lang.NoSuchFieldError: TIMESTAMP
        at org.joda.time.contrib.hibernate.PersistentDateTime.nullSafeSet(PersistentDateTime.java:83)

so how to set in createQuery criteria.

score 2 · Accepted Answer · edited May 23 '17 at 10:24

2

You can use custom user types created for joda-time. You can download it here

Persisting Joda DateTime instead of Java Date in Hibernate

edited May 23 '17 at 10:24

Community

1
1

answered Feb 21 '11 at 13:51

Aravind Yarram

78,777
46
231
327

score 2 · Answer 2 · answered Apr 16 '11 at 20:55

2

Please take a look at my project, http://usertype.sourceforge.net/ which will let you map Joda Time to Hibernate.

Thanks Chris

answered Apr 16 '11 at 20:55

Chris Pheby

323
1
8

joda.time.DateTime with hibernate createQuery to setDate

2 Answers2