Query between two dates + another column is not working in Hibernate 5

Question

I am able to fetch records using

`Criteria crit = session.createCriteria(GenerateInvoiceBean.class);
crit.add(Restrictions.eq("dealerId", dealerId)).add(Restrictions.between("billDate", frDate, tDate));
List<GenerateInvoiceBean> gib = crit.list();
            return gib;`

As createCriteria is deprecated in Hibernate 5.1.16, I am trying to use

`CriteriaBuilder builder = session.getCriteriaBuilder();
            CriteriaQuery<GenerateInvoiceBean> query = builder.createQuery(GenerateInvoiceBean.class);

            Root<GenerateInvoiceBean> root = query.from(GenerateInvoiceBean.class);
            query.select(root).where(builder.equal(root.get("dealerId"), dealerId)).where(builder.between(root.get("billDate"), frDate, tDate))
            .orderBy(builder.asc(root.get("billNo")));

            List<GenerateInvoiceBean> gib = session.createQuery(query).getResultList();
            return gib;`

which is not working. Any solution or suggestion would be great! Thanks

why are you calling where multiple times? It will use the last one only! Pass multiple clauses in to the sole call to where. Clearly "is not working" ought to have lead you to look at the LOG for the JPA provider and decide WHAT "is not working", and then tell people that — user8558216
– user8558216, Commented Apr 30, 2018 at 14:32
Yes you are right @DN1 Sir, only the last where part is working. Can you help me resolving it? Hibernate: select * from Invoice generatein0_ where generatein0_.bill_date between ? and ? order by generatein0_.bill_no asc Hibernate is resolved to this query on log. — Nizamuddin Shaikh
– Nizamuddin Shaikh, Commented Apr 30, 2018 at 14:42
I already did, above. where can take in MULTIPLE clauses. So pass in multiple clauses to a single call of where!! — user8558216
– user8558216, Commented Apr 30, 2018 at 14:44
That solved it! Thanks a lot Sir @DN1 ps:I overlooked that multiple clauses comment, sorry. — Nizamuddin Shaikh
– Nizamuddin Shaikh, Commented Apr 30, 2018 at 14:47

user8558216 · Accepted Answer · 2018-04-30 15:29:51Z

1

Change your CriteriaQuery call to be

query.select(root)
    .where(builder.equal(root.get("dealerId"), dealerId), 
           builder.between(root.get("billDate"), frDate, tDate))
    .orderBy(builder.asc(root.get("billNo")));

Collectives™ on Stack Overflow

Query between two dates + another column is not working in Hibernate 5

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related