I have a problem with using local transactions. I have a flow service in which I am using two adapter services one pointing to Oracle and the other pointing to Sybase systems. Both the adapter connections are using LOCAL_TRANSACTION only.
When i tried executing the service it worked fine initially. Later on I got a problem saying “Transaction is active”. Then I went in implementing the start and commit transactions for which it worked fine for some days. But now it throws an error saying “unable to commmit transaction”. I have put the start and commit transactions to the adapter service which is connecting to Sybase system and the Oracle adapter service do not have any transaction.
I have tried many ways to solve this but could not. I have tried in disabling and enabling the cascade adapter connection multiple times and also tried by removing the transactions totally.It still throws the same error. Can anyone throw some light on this.
Thanks in advance,