Subject Foreign-key integrety violation on delete
Author paulbramble
I am having an intermittant problem with deletes.

Our system runs under JBoss.

I have a hierarchical structure of 11 tables. Because our product
must run against multiple vendor's rdbms, I hard coded some of the
deletes. I start deleting my tree from the bottom up. However,
when I try to delete the topmost object, I get an error stating an
integrety constraint on a foreign key is violated. (don't have the
error code of the violation).

I am sure everything has been deleted under the top level object.
There are only 10 possible tables in which sub-tending data can
reside, and I can see that all 10 deletes have been executed. And
the data is gone.

Any ideas as to what is going on?