Subject Re: [Firebird-Java] Foreign-key integrety violation on delete
Author Karl Zellnig
On Fri, 23 Sep 2005 21:37:36 +0200, paulbramble <pdbramble@...> wrote:

> 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?
> Thanks,
> Paul

Is it possible that you use this table in a stored procedure?

Because of stored procs use internal references.