HQL vs criteria API vs pure criteria API
You have three options: 1) If you are not pinned to Critera api, I recommend to use HQL instead of Criteria API Date d = new SimpleDateFormat(« yyyy-MM-dd »).parse(« 2014-10-12 »); Query query = session.createQuery(« select count(*) from Visit v where trunc(v.date)=:date and v.visitor.id=:visitorId »); query.setParameter(« date », d); query.setParameter(« visitorId », 1L); Long count = (Long) query.uniqueResult(); 2) If you want to use Criteria … Lire la suite HQL vs criteria API vs pure criteria API