Using hibernate criteria query (distinct) in DAO to get refined result from db

[Vinod Vinu]

hi, iam trying to put distinct in hibernate criteria query but unable to get the desired result.

what i want ?
there are many records in db. It might be possible that some of those records belong to the same category.

i want to use projection, or distinct in dao to fetch those all records belonging to that same category i.e. on jsp only those records belonging to same category must be visible for once in grid.

please give me some hint or idea to achieve this.

thanks in advance

[Vinod Vinu]

somebody please tell me