Kbase P131675: Can an AppServer being used from a .NET client participate in a distributed transaction with externa
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/20/2008 |
|
Status: Unverified
GOAL:
Can an AppServer being used from a .NET client participate in a distributed transaction with external databases being used directly from the client?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The AppServer cannot directly participate in a distributed transaction when the transaction spans databases directly connected to by the .NET client.
However, by using the TRANSACTION-MODE AUTOMATIC statement it is possible to programmatically keep the ABL transaction on the AppServer open beyond a single call to the AppServer thereby allowing the developer to apply all changes to the AppServer and the directly connected databases then invoking either the SET-COMMIT or SET-ROLLBACK methods on the AppServer to finish committing or rolling back the transaction on the AppServer side.