Applying unique constraint on one col of primary key.

pdommara · **Joined:** Mon Oct 30, 2006 12:46 am **Posts:** 26

Hi

I am getting duplicate set rows for one query.But i want to display only
unique rows.

I thougt of doing queryResult.uniqueResult() but it seems it will apply
key on primary key

Here my primary key is : a+b+c+d

My requirement is : i want to get list of data of unique of b.

Is there any way to get this way .

Pls help me !! urgent !!

Thanks
Praveen

batmat · **Posted:** Thu Jun 21, 2007 1:34 pm

I guess your problem has nothing to do with unique constraint (in the db I mean). Didn't you use outer joins?

If so, call setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY) before calling list().

HTH

pdommara · **Joined:** Mon Oct 30, 2006 12:46 am **Posts:** 26

Hi ,

But i am using QueryObject rather than criteria to get the records from
database.

Pls could you tell is there any way todo this using QueryObject.

Pls help me !!

batmat · **Posted:** Fri Jun 22, 2007 11:31 am

"select distinct ..." could do it, but I seem to remember it is only available since Hibernate 3.2.

If you're using Hibernate < 3.2, then use something like :

Code:

List results = new ArrayList(new HashSet(yourQuery.list()));