distributed transaction

distributed transaction

  
Hi,

How can manage a distributed transaction with an Outsystems Database and another resource database like DB2?

Is there a way to implement a 2 phase commit between outsystems and another resource?

thanks in advance.
Rodrigo
Hi Rodrigo,

To accomplish that I believe you would need to configure linked servers and MSDTC to work correctly with DB2 in the SQL server. If you are connecting to DB2 using custom extensions the only thing you could do is to explicitly call a DB2 commit in the end of OutSystems actions (and rollback in case of exception). That would not be a real 2 phase commit, but would probably cover what you need. If you need more help I would suggest that you contact support@outsystems.com with your detailed scenario.

Cheers,
Tiago Simões