OK so here is the problem: I have a many to many association between ProjectProfile and DeveloperProfile.... I am aware that there are allot of posts regarding many-to-many associations but I can't seem to find the answer to a simple question:

how can I delete just the association between a project and a developer(in my case)

thank you


Hibernate version:
3.1.2

Mapping documents:
<hibernate-mapping
>
<class
name="net.sourceforge.lebon.model.DeveloperProfile"
table="DeveloperProfile"
>

<id
name="id"
column="ID"
type="java.lang.Long"
>
<generator class="assigned">
<param name="sequence">DEVP_SEQ</param>
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-DeveloperProfile.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>

<timestamp
name="modifiedAt"
column="modified_at"
access="property"
unsaved-value="null"
/>

<set
name="projects"
table="DeveloperWork"
lazy="true"
cascade="save-update"
sort="unsorted"
>

<key
column="developer_id"
>
</key>

<many-to-many
class="net.sourceforge.lebon.model.ProjectProfile"
column="project_id"
outer-join="auto"
/>

</set>
............

<hibernate-mapping
>
<class
name="net.sourceforge.lebon.model.ProjectProfile"
table="ProjectProfile"
>

<id
name="id"
column="ID"
type="java.lang.Long"
>
<generator class="assigned">
<param name="sequence">PRP_SEQ</param>
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-ProjectProfile.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>

<timestamp
name="modifiedAt"
column="modified_at"
access="property"
unsaved-value="null"
/>

<set
name="developers"
table="DeveloperWork"
lazy="true"
cascade="save-update"
sort="unsorted"
>

<key
column="project_id"
>
</key>

<many-to-many
class="net.sourceforge.lebon.model.DeveloperProfile"
column="developer_id"
outer-join="auto"
/>

</set>
...........

Name and version of the database you are using:
HSQLDB

Something like this =)



Maybe you have to make it at the other side too, depends of your mapping
Hope I could help =)

ok... fair enough...

but I tried that with the save method below and it didn't work :(

update:

in the end I made an SQL query to solve this.. It's not the best way to go but I can't find any other solution... If anybody has any ideas I am opened to suggestions...

Thank You