"Unspecified" Transaction after creation..

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

"Unspecified" Transaction after creation..

Joslat
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

Reply | Threaded
Open this post in threaded view
|

Re: "Unspecified" Transaction after creation..

Jiří Činčura-2
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


------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: "Unspecified" Transaction after creation..

Joslat
This post was updated on .
Thanks for your response, Jiří !

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).

 
Reply | Threaded
Open this post in threaded view
|

Re: "Unspecified" Transaction after creation..

Jiří Činčura-2
> 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

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: "Unspecified" Transaction after creation..

Joslat
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
Reply | Threaded
Open this post in threaded view
|

Re: "Unspecified" Transaction after creation..

Jiří Činčura-2
> 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

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider