Fixtures.deleteAll() doesn't work with PostgreSQL or Oracle

[thelinuxlich]

These two RDBMS doesn't have an easy way to disable referential integrity check like mySQL, so Play will always complain about foreign key constraints.

[thelinuxlich (thelinuxlich)]

A new fix to handle schema owner with oracle driver

[Guillaume Bort (guillaume-bort)]

I don't understand how your fix work. Can you make it simpler? Without using a shared state ...

[thelinuxlich (thelinuxlich)]

It's difficult to abstract more because these two RDBMS doesn't have an easy way to disable referential integrity check without looking into the schema metadata, dropping and creating constraints on the fly.

[[e-mail] (nicolas-martignole)]

Confirmed with Play 1.0.3 and Oracle

In getForeignKeyToggleStmt we need to execute 2 statements:
- one statement to prepare a list of ALTER TABLE
- one statement with all the ALTER TABLE operation

Problem is that getForeignKeyToggleStmt is not designed to execute 2 statements,
so we will have to dig a little bit more

I'll try to propose a fix too asap

Nicolas