Unable to clean database - Foreign Key Referential integrity constraint violation

[cezarygerard]

Hi,

I have cleaning up database after test. Here is the way I annotate my tests:

	@Test
	@InSequence(6)
	@UsingDataSet("someData.xml")

The problem Unable to clean database is caused by Foreign Key constraint. When I annotate with @Cleanup(strategy = CleanupStrategy.USED_TABLES_ONLY then it is possible to run the test (if tables in someData.xml occur in correct sequence).

But until recently everything worked just fine, without @Cleanup. My problem is that I will have to annotate and create hundreds of datasets used in tests.

Can anyone give me a clue what might have changed so now I have to annotate every test which uses tables related by foreign key?

I use arquillian-persistence-dbunit 1.0.0.Alpha7. In the past I used to work with 1.0.0.Alpha6

Thank you in advance,

Regards

Czarek

Wiadomość była edytowana przez: Cezay Zawadka

[bmajsak]

Can you share your case somehow? (GitHub for example)

I will investigate.

[sbiermann]

Hi,

i have the same problem. i have make a short github project based on my project. You can find it here: sbiermann/arquillian-persistence-test · GitHub

[bmajsak]

Thanks for sharing. I will look at it this weekend.

[luc4]

Any news on this? I face the same issue when i try to upgrade to alpha 7.

[tvibes]

Cezay Cezay a écrit:

But until recently everything worked just fine, without @Cleanup. My problem is that I will have to annotate and create hundreds of datasets used in tests.

The Cleanup startegy can be set globally in arquillian.xml. The default is 'STRICT' but you can set 'USED_TABLES_ONLY' and you won't need to annotate each test class:

Persistence - Arquillian - Project Documentation Editor

Though, I don't know why the upgrade to alpha7 version breaks your tests.