DetachedCriteria & Distinct on a table not just a proper

RolfZe · **Joined:** Sun Mar 05, 2006 7:36 pm **Posts:** 4

Hi

I try to figure out how to use the distinct projection object with the DetachedCriteria on a table and not just a column(property) of a table.

For a property it would be like this:

Code:

Criteria cr = session.createCriteria("hr.klopa.domain.FoodItem").setProjection(Projections.distinct(Projections.property("name"))); 

but how can I use the destinct feature on the whole table and not just on a property e.g. select distinct * from table

Any help is very much appreciated

Cheers
Rolf

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Yep, there are a couple of ways. Projections.property("this") is the equivalent of * in that situation, I think. You should end up with "distinct col1 as col11_, col2 as col21_, ..." in your generated SQL, so it'll be more verbose than "distinct *" but completely analagous.

If that doesn't work, this should:

Code:

Projections.sqlProjection("distinct *", String[] {""}, Type[] {Hibernate.INTEGER})