Hibernate Community • View topic - Problem with Date HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Problem with Date HQL

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

shearer

Post subject: Problem with Date HQL

Posted: Fri Nov 02, 2007 5:20 pm

Newbie

Joined: Sat Oct 27, 2007 12:32 pm
Posts: 2

Hi Im trying to figure out what's wrong with this query

" from terminals te where te.creationDate between " + creationDateInit + " and " + creationDateEnd

When I run this query i got an error
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: Nov

The query translates something like this

te.creationDate between Mon Nov 26 00:00:00 GMT 2007 and Thu Nov 29 23:59:59 GMT 2007

Any Idea??

Top

kid1125

Post subject:

Posted: Fri Nov 02, 2007 8:58 pm

Newbie

Joined: Wed Oct 31, 2007 5:36 pm
Posts: 13

Your query string becomes a string literal after the toString() is executed on the date objects.

You should do something like this:

Code:

String hql = "from terminals te where te.creationDate between :start and :end";

List results = session.createQuery(hql).setTimestamp("start", creationDateInit).setTimestamp("end", creationDateEnd).list();

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum