OK, got it:
(e) Because FbConnections cannot be enlisted dynamically but only during Open(),
the prepared command will not need to have the Transaction property set as
it always takes the current enlisted transaction from the connection
during Prepare().
It also means to me, that the using Prepared Statements does not make
sense with the current
implementation of the Ado driver.
""Thomas Krüger"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> Hi,
>
> I'm having difficulties understanding the System.Transcaction Integration
> for FbConnection.
> (a) Why is it not possible to enlist in a transaction dynamically?
> One has to use Enlist=true in the connection string during Open() to
> get a _enlisted_ connection.
> What if I want to enlist dynamically later? The EnlistTransaction()
> should do that, but it does
> not do what the name says, as it requires the Enlist option to be set.
> And that can only be set
> from the connection string for Open() ....
> If one looks at the Oracle provider, there we have a
> Enlist=false/true/dynamic setting which
> actually better describes the configuration. Even better would be to
> allow dynamic enlistment
> without looking at the connection string options; that should be
> possible.
> (b) If Enlist=true is given during Open(), but no System.Transaction is
> returned from System.Transaction.Current,
> the data provider crashes.
> (c) The isolation level is hard wired to be ReadCommitted, despite what the
> System.Transactions.Transaction
> instance says. This makes it practically impossible to use other
> isolation levels with Firebird although
> that would easily be possible.
> (d) It seems there is no real prepare phase and not a real integration into
> MSDTC supporting reenlistment
> in case of a crashed MSDTC. Is this documented somewhere or am I
> missing something?
> (e) It seems to me that prepared statements cannot be used in an enlisted
> transaction as one is not
> able to obtain the database transaction to set that to
> FbCommand.Transaction.
>
> Is anyone else having success with the System.Transaction Integration?
> Thanks -
>
> Thomas
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
