I'm trying to define eager-load and lazy-load groups to optimize accesses on a bean that have many CMR fields returning collections.
for exemple imagine a club that has fields to store their members, phone numbers. and in the other hand some members could be members of other club, so theres relation tables to manage those n-n relations
In jbosscmp-jdbc this relationship is based on a relation-table, so there's no foreign key field definition in the relationship-role section.
As only CMR fields that have a foreign key can be a member of a load group, how is it possible to manage those CMR field retrieving collections through a relation table?

Thanks for any help
Philippe