Hibernate Community • View topic - Criteria sentence to find dates between today

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Criteria sentence to find dates between today

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

alexsaura

Post subject: Criteria sentence to find dates between today

Posted: Tue Jun 27, 2017 4:42 am

Newbie

Joined: Tue Jun 27, 2017 4:34 am
Posts: 1

Hi everybody,

I need to find the result of two dates when today's date is between them.

Date fechahoy = new Date();
MClientesMTarifas mcmt = (MClientesMTarifas) getSession().createCriteria(MClientesMTarifas.class)
.add(Restrictions.eq("idcliente_cliente", idcliente))
.add(Restrictions.between(today, "fechainicio", "fechafin"))
.uniqueResult();

And I get this error:
GRAVE: org.hibernate.QueryException: could not resolve property: today of: org.dpsistem.spring.model.cliente.MClientesMTarifas

How can I get this result???

Thanks.

Top

vlad

Post subject: Re: Criteria sentence to find dates between today

Posted: Tue Jun 27, 2017 5:20 am

Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1628
Location: Romania

The way you call the between method:

Code:

.add(Restrictions.between(today, "fechainicio", "fechafin"))

Does not match the way it was intended to be used. Follow the method signature and the match the parameters accordingly: