Subject Re: [Firebird-devel] external data sources
Author Jim Starkey
Roman Rokytskyy wrote:

>External procedures described in that document cannot be used for such
>purposes, because current document does not allow procedures actively
>participate in deciding the transaction outcome, in other words, currently
>procedure interface does not have methods to tell server if "prepare"
>succeeded, and to be notified about either "commit" or "rollback" decision.
>This limitation does not allow procedure to start some tx on remote host,
>prepare it in prepare phase and commit or rollback it in the second phase of
>So, either concept of external procedures should be extended, or some other
>mechanism should be invented.
It is clear to me that the mechanism should be beefed up to support
external transactions. In many cases, the external system may not
support transaction or may have a model that doesn't integrate well, but
in most cases, unified transactions are straightforward and natural.


Jim Starkey
Netfrastructure, Inc.
978 526-1376