problem when retrieve data from hibernate many to many relationship

Question

i have two table with many to many relationship when i apply findbyall method to this table it will retrieve one record multiple time (that is the record will be displayed for this perticular table as many time as there are different relation ship with other table) so how can i display each record once only. thank in advance.

Answer 1

Add the 'distinct' transformer to your Criteria object, like so: crit.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);