Hi,

I have a relationship many-to-many betwwen Manager and Responsible

Hibernate version: 2.1.4
Name and version of the database you are using: Oracle 9i

Mapping documents:

// Manager

<hibernate-mapping>
<class name="proj.register.ManagerTO" table="gestor">
<id name="idManager" column="id_gestor">
<generator class="assigned"/>
</id>
<property name="naManager" column="no_gestor"/>
<bag name="responsibles" table="gestor_x_responsavel" lazy="false" cascade="all">
<key column="id_gestor"/>
<many-to-many class="proj.register.ResponsibleTO"
column="id_responsavel"/>
</bag>
</class>

</hibernate-mapping>


// Responsible

<hibernate-mapping>
<class name="proj.register.ResponsibleTO" table="responsavel">
<id name="idResponsible" column="id_responsavel">
<generator class="assigned"/>
</id>
<property name="naResponsible" column="no_responsavel"/>
<bag name="managers" table="gestor_x_responsavel" inverse="true" lazy="false" cascade="all">
<key column="id_responsavel"/>
<many-to-many class="proj.register.ManagerTO" column="id_gestor"/>
</class>
</hibernate-mapping>



when I try execute the session.delete(manager),
it is deleted the relationship and the responsible objects too,
but I need delete only the relationship between the manager and resposible.

How can I do this???

thanks!!

manager.getResponsibles().remove(responsible)
responsible.getManagers().remove(manager)

In the example of many-to-many association(manager-responsible), anther table will be generated when exportschema(say Manager-responsible), with two forgeign key to ids of them, and the two foreign combine as the key.

For below deletion: is it one SQL or two, if two, it seems that the not-null constraints will be violated?
manager.getResponsibles().remove(responsible)
responsible.getManagers().remove(manager)

It seems tricky for many-to-many association because the relationship table is not assocaited with a persistent class, is there other decent alternatives for this mappying.

Thanks