@PersistenceTest vs @Transactional in Arquillian persistence extension

[esteve]

Hi,

I have a persistence test replicated, one uses @PersistenceTest class level annotation and the other user @Transactional annotation for each test.

The class has three tests.

With @Transactional annotation all tests end successfully. With @PersistenceTest, and without @Transactional, the segond transactional test always fails with a SQL exception.

I have shared the project on github: https://github.com/esteveavi/sandbox

You can run the test:

With @Transactional annotation: --> Works OK

mvn test -Dtest=CustomerTransactionalTest -Parq-jboss_as_managed_7.x

With  @PersistenceTest annotation: --> Fails on test 3

mvn test -Dtest=CustomerPersistenceTest -Parq-jboss_as_managed_7.x

Thanks in advance.

Regards.

Esteve

[bmajsak]

Hi Esteve,

thanks for sharing. I just forked your project and will look at it this evening after work. (in about 10h or so )

Cheers,

Bartosz

[bmajsak]

Hi Esteve,

I spent some time looking at it but I cannot clearly say yet what is exactly causing this confusing behaviour. Sadly I'm going for holidays today... and won't have a chance to look at it before 12.05... Let me know in the meantime if you solved the problem (or maybe somebody else from the community will pick it up). I will go back to it upon my arrival.

Cheers,

Bartosz

[esteve]

Bartosz,

Don't worry. It works with @Transactional method annotation.

Enjoy your holidays.

Regards,

Esteve