[arquillian-issues] [JBoss JIRA] (ARQ-1942) Duplicate PK encountered when using a ApplyScriptBefore script

[Dimitrios Kordas (JIRA)]

    [ https://issues.jboss.org/browse/ARQ-1942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13058850#comment-13058850 ] 

Dimitrios Kordas commented on ARQ-1942:
---------------------------------------

After more close inspection (and closer reading of the docs) i can see that my problem is this:

I have not defined a defaultCleanupStrategy strategy, so arquillian defaults to STRICT.
I have also not defined a excludeTablesFromCleanup table list with the effect that after the 1st test method (within the same test) the sequences tables and my own tables are being emptied, leading to the errors i have gotten.

I have now defined a wildcard excludeTablesFromCleanup setting and a UsingDataSet only on the 1st method and it works.

> Duplicate PK encountered when using a ApplyScriptBefore script
> --------------------------------------------------------------
>
>                 Key: ARQ-1942
>                 URL: https://issues.jboss.org/browse/ARQ-1942
>             Project: Arquillian
>          Issue Type: Bug
>          Components: Extension - Persistence
>    Affects Versions: persistence_1.0.0.Alpha6, persistence_1.0.0.Alpha7
>         Environment: Windows 8.1 Home, WildFly 8.2.0 Final, jdk1.8.0.40
>            Reporter: Dimitrios Kordas
>            Assignee: Bartosz Majsak
>
> I am trying to create tests for hibernate under WildFly 8.2.0.
> I can successfully create the war using Shrinkwrap, but when Arquillian tries to run the script i provided using the @ApplyScriptBefore annotation hibernate complains about duplicate primary keys even though all keys defined are sequential.
> I encounter this error for specific primary keys. For example 1.
> If i run the same script (only with an id of 2) multiple times it works.
> I have tested the same thing using yaml and json formats and it doesn't work either.
> INSERT INTO app_category(id, description, name) VALUES(1, 'entertainment apps', 'Entertainment');
> INSERT INTO app(id,active,fqn,name,app_category_id) VALUES(1,true,'com.facebook','Facebook',1);
> INSERT INTO app(id,active,fqn,name,app_category_id) VALUES(2,true,'com.twitter','Twitter',1);
> INSERT INTO app(id,active,fqn,name,app_category_id) VALUES(3,true,'com.instagram','Instagram',1);



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)