Hi,

I have a query like this (get all ships which are from a given firm):
List ships = session.createCriteria(Ship.class) .createAlias("relations", "r").add(Restrictions.eq("r.ship", firm)).list();

relations is a inverse relation in ship.hbm.xml:
<bag name="relations" inverse="true" lazy="true" cascade="all">
<key column="ship_id"/>
<one-to-many class="FirmShip"/>
</bag>

The problem is now I get the correct ships but some are double (because they can be double in the relation table firmship)

uniqueResult is no solution because it can be more than one ships. I need a list.

Regards, Detlev

I made a mistake in my above message:
List ships = session.createCriteria(Ship.class).createAlias("relations", "r").add(Restrictions.eq("r.firm", firm)).list();

r relates to table firmtrade or better class FirmTrade with attributes firm, ship, ownerfrom (date), owneruntil (date)
And have a firm a ship sold and then the same again bought, I have with my query this ship double.

Is it possible with Hibernate to return unique sets?

nobody an idea?

Thank you very much, Detlev