Hi,

I know that Hibernate doesn't handle nested collections. Can anyone recommend, then, how to map this relationship

TABLE payee
- payee_id (PK)

TABLE payment_detail
- detail_id (PK)
- payee_id (FK)
- payment_type


given I'd like to be able to do the following:

{
// ...
Payeee payee = // load payee by id ...
Set paymentsType1 = payee.getPaymentOfType(type1);
Set paymentsType2 = payee.getPaymentsOfType(type2);
}

the set of payment types is open ended.


Thanks
Dmitry

use a <map>?

I thought Hibernate did not allow Map<Set> (nested collections)? When I do try to use a map, the map value only contains a single object

<map name="paymentsByDos" table="pmnt_detail" access="field" >
<key column="ucsd_id"/>
<index column="dos_code" type="string"/>
<one-to-many class="edu.ucsd.som.onlinepayments.business.PaymentDetail"/>
</map>

a clarification please? thx