CMP recursive delete in autoreferencing table

[milesif]

Hi everybody

Is it possible in JBoss 2.4 or in Jboss 3.0 to make
recursive delete in a single "requires" transaction of record belonging to an autoreferencing table that has three fields ID, NAME, PARENT that is FK on ID ?

Thanks in advance

Ciao Francesco

[dsundstrom]

Sure, you can do what ever you want in a transaction, but I don't think that is what you mean.

Did you mean cascade delete? If so, CMP 2.0 relationships can automatically perform cascade delete.

[milesif]

Thanks dsuntsrom

cascade deletes are what I meant: I have a tree and when I delete a node I want all the subtree deleted.

Ciao Francesco