check exists in hibernate criteria API

Question

How to best express "exists" query with Hibernate Criteria?

In my project, people use count projections to check if any row matches the criteria (count > 0). To be more effective, I prefer using exists instead.

Here is the base code for counting by criteria:

public int count(final DetachedCriteria criteria) throws DataAccessException {

    Object countResult =  executeWithNativeSession(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException {
            Criteria executableCriteria = criteria.getExecutableCriteria(session);
            executableCriteria.setProjection(Projections.rowCount());

            prepareCriteria(executableCriteria);

            return executableCriteria.uniqueResult();
        }
    });
    if (countResult == null) {
        countResult = 0;
    }

    return (Integer) countResult;
}

There is no question. Also, as far as I know, it is fairly common to use count as exists criteria. — Nikola Yovchev
– Nikola Yovchev, Commented Nov 5, 2013 at 9:01

JCalcines · Accepted Answer · 2013-11-05 09:59:05Z

11

Sometime ago, I had the same doubt and I thought that It is unefficient. So what I do now I search the first coincidence and that is faster.

protected boolean exists(final Criteria query) {
    query.setProjection(Projections.id());
    query.setMaxResults(1);
    return query.uniqueResult() != null;
}

I hope that helps.

answered Nov 5, 2013 at 9:59

JCalcines

1,28612 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

check exists in hibernate criteria API

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