firebird-net-provider

[Firebird-net-provider] "Unspecified" Transaction after creation..

[Joslat <jos...@ro...>]

Hi,

There is any way to validate the Transaction configuration after Starting
it?
If I create a transaction options with FbTransactionBehavior.Wait, for
example, And start the transaction with BeginTransaction, like: 
this.conn.BeginTransaction(new FbTransactionOptions() { TransactionBehavior
= FbTransactionBehavior.Wait});

After this the transaction object on the connection appears as
"unspecified".
How can I check the current active transaction options of the current
transaction? 

Thanks,
Jose





--
View this message in context: http://firebird.1100200.n4.nabble.com/Unspecified-Transaction-after-creation-tp4643287.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

Re: [Firebird-net-provider] "Unspecified" Transaction after creation..

[Jiří Č. <ji...@ci...>]

If you want something else then Unspecified (which, looking at the code
might actually rather be some reasonable default), you have to specify
the isolation level.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] "Unspecified" Transaction after creation..

[Joslat <jos...@ro...>]

So, for example, if I want a Save-Update operation I should put all the
transaction options specifically, like:
                to = new FbTransactionOptions()
                {
                    TransactionBehavior =
                                          FbTransactionBehavior.Protected |
                                          FbTransactionBehavior.Write |
                                         
FbTransactionBehavior.ReadCommitted | 
                                          FbTransactionBehavior.RecVersion |    
                                          FbTransactionBehavior.Wait            
                };                
And, obviously, Begin the transaction..

My guess was that the "default" firebird options were respected. Is that not
allright?

If I put, for example, only the FbTransactionBehavior.Wait, what would be
the behavior then?

I tried to reach out to several references but so far none explains what
behavior is to be expected under this condition
(FbTransactionBehavior.Wait).

 



--
View this message in context: http://firebird.1100200.n4.nabble.com/Unspecified-Transaction-after-creation-tp4643287p4643297.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

Re: [Firebird-net-provider] "Unspecified" Transaction after creation..

[Jiří Č. <ji...@ci...>]

> So, for example, if I want a Save-Update operation I should put all the

I don't know what that means.

> My guess was that the "default" firebird options were respected. Is that
> not
> allright?

Really the default in provider is Write | NoWait | ReadCommitted |
RecVersion. Once you start specifying your own, you're on your own.

> I tried to reach out to several references but so far none explains what
> behavior is to be expected under this condition
> (FbTransactionBehavior.Wait).

That's kind of invalid. You're not specifying TIL.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] "Unspecified" Transaction after creation..

[Joslat <jos...@ro...>]

That's kind of invalid. You're not specifying TIL.
Thanks for the amazingly quick response, appreciated!!

>> So, for example, if I want a Save-Update operation I should put all the
>I don't know what that means.
Just the options for a transaction that performs a simple Update operation.

>> My guess was that the "default" firebird options were respected. Is that
>> not  allright?
>Really the default in provider is Write | NoWait | ReadCommitted |
>RecVersion. Once you start specifying your own, you're on your own.
Great, so specifying any option, means that we have to specify everyhting.
Clearly understood!

>> I tried to reach out to several references but so far none explains what
>> behavior is to be expected under this condition
>> (FbTransactionBehavior.Wait).
>That's kind of invalid. You're not specifying TIL. 

Grand! so any code with that is wrong. Understood! if TIL (Transaction
Isolation Level, right?) is not specified, what would be firebird's behavior
then? 

Best,
Jose




--
View this message in context: http://firebird.1100200.n4.nabble.com/Unspecified-Transaction-after-creation-tp4643287p4643299.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

Re: [Firebird-net-provider] "Unspecified" Transaction after creation..

[Jiří Č. <ji...@ci...>]

> Just the options for a transaction that performs a simple Update
> operation.

So you need write transaction.
 
> Grand! so any code with that is wrong. Understood! if TIL (Transaction
> Isolation Level, right?) is not specified, what would be firebird's
> behavior
> then? 

I don't know. You're probably need to check engine's code. Nobody same
would rely on that, I suppose.

-- 
Mgr. Jiří Činčura
Independent IT Specialist