firebird-net-provider

RE: [Firebird-net-provider] Query hang

[Andrew G. <ag...@jc...>]

Carlos,

I'm using 1.0.1220.28609, but I also tried 1.5.1491.18298 on my test server
and the samething happens.
I can't be bothered to change all my Fbtype to FBdbType right now :)

The deafult in .net provider is:
"Begins a new transaction with the default isolation level
IsolationLevel.ReadCommitted."

I don't know about the subsets you mentioned.

Do you have an example code of how to change the isolation level? I'm not
sure I was doing it right on my testing, as it said I needed to use an
integer for the isolationlevel, and I could find no doc on that.

Do you know what isolation level I should use? 

TIA

Regards,
 
Andrew C. Goodall

Regards,
 

RE: [Firebird-net-provider] Query hang

[Andrew G. <ag...@jc...>]

> Why would database workbench and ibconsole run the query, but through 
> asp.net it hangs?

Ok I asked Database Workbench support what isolation level they use, and
they said:
"read committed", with "no wait" for deadlocks.

However I could not find this as a valid option on System.Data.Isolation
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemdataisolationlevelclasstopic.asp

Readuncommited is the option that will allow dirty reads and prevent
deadlocking.

So I used:
myTxn = myConnection.BeginTransaction(IsolationLevel.Readuncommitted)

And it works fine now - no hanging :)

My next question is:
In my asp.net page I want to pull up a single record but want to check to
see if someone else
Has this record uncommited first.
If I use IsolationLevel.Readcommitted the webpage will hang if the record is
locked,
If I use IsolationLevel.Readuncommitted the page will load but the data will
be ditry.

How can I check, or what is the best method to see if a record has a lock?

TIA

Regards,
 
Andrew C. Goodall
 

Re: [Firebird-net-provider] Query hang

[<car...@te...>]

Hello:

> And it works fine now - no hanging :)

:)

> How can I check, or what is the best method to see if a record has a lock?

This is a good question for firebird-support list ;)

( 1.6 version of the provider will allow to use Firebird specific 
transaction parameters, this iwll allow to have better control over 
transactions. )




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Query hang

[<car...@te...>]

Hello:

> The deafult in .net provider is:
> "Begins a new transaction with the default isolation level
> IsolationLevel.ReadCommitted."

Yes, ReadCommitted is the default Isolation Level.

> I don't know about the subsets you mentioned.

Review the Interbase 6 API documentation for see more information about 
them:

http://www.ibphoenix.com/downloads/60ApiGuide.zip

> Do you have an example code of how to change the isolation level? 

The isolation level is specified in FbConnection.BeginTransaction method 
and can't be canged ( querys using the implicit transaction support will 
use ReadCommitted )



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain