For the error I am seeing now for h2 database, I don't have 2 remote web service calls. I have only one rest web service and it is updating h2 database. I get 'Database may be already in use: \"Locked by another process\" when I try to deploy the service. I got this error before and I restarted my computer and I was able to deploy again.
Our current scenario in the company is, we have one rest web service which calls another rest web service and both of them update same oracle database. So do you think I can't use Narayana for my scenario.
Just to mention with help from zhfeng I managed to get the arquillian working:
Comparing jbosstm:master...tomjenkinson:springExampleinWFLY · jbosstm/quickstart · GitHub
mvn clean install should do it
You can see the rollback and commit are working as expected
I see that error myself when I ran the test, it looked like a locks held in h2 and I was able to resolve by deleting the database files Obviously you wouldn't want to do that in production but it is an application error somewhere like leaving the database prepared and not committing it or running two process at the same time.
Thanks Tom. I will give it a try ..
I was able to get 1 rest web service transactional. Thank you Tom. I am going to create another same type of rest web service and call it from this web service.
No problem - good luck!