I don't use Hibernate, and didn't write the sub-project, however, you might want to consider one of the LocalDate types:
http://joda-time.sourceforge.net/contrib/hibernate/api-release/index.html Stephen Rob Hills wrote: > I am using a Hibernate named sql query in my app, which contains a > clause "where deliverydate between :startdate and :enddate". > > In my java code, I'm loading this into an org.hibernate.Query object and > then setting the parameter values like this: > > Query query = session.getNamedQuery("delivery.date.range"); > query.setParameter("startdate", startDate); > query.setParameter("enddate", endDate); > return query.list(); > > When I executed this code, I got the following error: > JDBCExceptionReporter.logExceptions | Error: operator does not exist > date >= bytea > > I had the feeling I should be specifying a type for my query parameters > (the setParameter method has a third parameter that is an > org.hibernate.Type type), but I couldn't find a value that seemed > suitable for a Joda LocalDate object. > > In the end, I supplied my date values as java.util.Date types like this: > > query.setParameter("startdate", startDate.toDateAtStartOfDay().toDate()); > > and that allows my tests to pass. However, I kind of expected the > joda-hibernate package to have some classes that implement the > org.hibernate.type > (http://www.hibernate.org/hib_docs/v3/api/org/hibernate/type/Type.html) > interface that could be used in query parameters. > > Has anyone else used joda date and/or time values in Hibernate named > queries? Can you provide any tips for new players? > > TIA, > > Rob Hills > Waikiki, Western Australia > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > Joda-interest mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/joda-interest > ------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ Joda-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/joda-interest
