Criteria + order distinct

subich · **Joined:** Fri Nov 21, 2003 5:55 am **Posts:** 155

Hi all,

I only want to know something about distinct with criteria. I saw that an implementation of distinct might be developped for Criteria and I want to know if it's released in the last version of Hibernate?
Sorry if this question is already answered but I only found old post about this subject.
Thanks in advance.

kind regards.

edovale · **Posted:** Wed Oct 19, 2005 1:53 pm

I am using hibernate-3.1beta1 and it already have a Projections.distinct(myprojection).

Hope it helps..

kochcp · **Posted:** Wed Oct 19, 2005 2:14 pm

edovale wrote:

I am using hibernate-3.1beta1 and it already have a Projections.distinct(myprojection).

I think the projection stuff only happens after all the results are queried from the database

for example

Code:

createCriteria(Some.class).setProjection(Projections.distinct(myprojection)).setMaxResults(20);

if the first 15 items were the same, you'd get 6 items back, instead of 20 distinct items from the db

edovale · **Posted:** Wed Oct 19, 2005 2:18 pm

kochcp wrote:

edovale wrote:

I am using hibernate-3.1beta1 and it already have a Projections.distinct(myprojection).

I think the projection stuff only happens after all the results are queried from the database

I don't think so. The projections actually affect the generated sql statement.

kochcp · **Posted:** Wed Oct 19, 2005 2:22 pm

edovale wrote:

I don't think so. The projections actually affect the generated sql statement.[/quote]

hmm, maybe I am thinking of setResultTransformer

kochcp · **Posted:** Wed Oct 19, 2005 2:33 pm

yeah, edovale is right, that puts distinct in the generated sql