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

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);