Hibernate get distinct list with Criteria

Apr 3rd, 2008

The only way I could figure out to get the distinct list using Hibernate Criteria is by using ResultTransformer function.

eg.

List result = session.createCriteria(Order.class)
        .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
        -------
        .list();

The con is it fetches all the objects and then filters it. (very time consuming)

The only way to circumvent this problem is to write query using HQL.

If you find a way to do that efficiently using Criteria, let me know 🙂

  1. Marius
    Sep 6th, 2013 at 01:48
    Reply | Quote | #1

    Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you. Thank you.

Time limit is exhausted. Please reload the CAPTCHA.