[dbunit-user] Problem with Foreign Keys to the table itself

[<jua...@gm...>]

Hi, I have a table with a foreign key to another column within itself.
When I execute deleteAll operation, I get a Foreign Key violation
error because the records are beeing deleted in the same order than
insertion. Im using a DatabaseSequenceFilter for solving the
inter-table dependency problem, but this does not solve the
dependencies problems within a table.

Im using HSQLDB for unit testings. Is there a way to solve this? I
mean, avoiding foreign key checks from dbunit? Or making dbunit make a
DROP table instead of DELETE? (Im creating the schema automatically
with hibernate everytime I run the tests)

Thanks!