Hibernate Community • View topic - problem with many-to-many delete

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

problem with many-to-many delete

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Pulverturm

Post subject: problem with many-to-many delete

Posted: Fri Feb 13, 2004 7:52 am

Newbie

Joined: Sat Oct 11, 2003 2:01 pm
Posts: 7

Hi,

I'm probably missing something, but shouldn't many-to-many sets behave the same way as composite-element sets in delete situation?

I have an entity which has many-to-many set without cascades (I don't want it to cascade over the link table). When I try to make session.delete("...") it fails, because link table foreign key constraints kick in.

Only delete I'm seeing in the log is the parent entitys. That's when it fails. Link table rows should be deleted first.

Code:

    <set 
        name="types"
        lazy="false"
        inverse="false"
        table="LINK"
        >
        <key>
            <column name="THING_ID" />
        </key>
        <many-to-many 
            column="TYPE_ID"
            class="zzz.Type" /> 
    </set>

...

session.delete("from Thing thing where thing.prop > 123");

Thanks in advance!

Top

Pulverturm

Post subject:

Posted: Fri Feb 13, 2004 9:22 am