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