How to add Distinct in Hibernate Criteria

hibernate, java

Solution

Use Projections.distinct.

Criteria crit = session.createCriteria(Test.class).setProjection(
    Projections.distinct(Projections.projectionList()
    .add(Projections.property("type"), "type") )
.setResultTransformer(Transformers.aliasToBean(YourBean.class)); 

List lst = crit.list();

where YourBean.class has a property "type". The returned list will be `List<YourBean>`.

Problem

In my database I have a Test table, with columns: testName, testType there are 2 different tests with the same type I.e "SUN", so I want only one of them for which I use Distinct in my hibernate / criteria as below, but it still giving me both the types with the same name as "sun". ``` Criteria crit = session.createCriteria(Test.class); final ResultTransformer trans = new DistinctRootEntityResultTransformer(); crit.setResultTransformer(trans); List rsList = trans.transformList(crit.list()); ``` Any idea what could be the reason, or any other way of filtering duplicates.

Original source