Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi all.
My colleague has a problem.
Anyone help the following ?
Here is my colleague' e-mail.
<<QUATE>>
Hi,
A question about set the isolation to informix cursor stability.
Usually we can set the isolation level like this,
cn.IsolationLevel = adXactReadUncommitted ' or adXactReadCommitted;
adXactCursorStability; adXactRepeatableRead
cn.BeginTrans
...
The problem is, in ADO adXactCursorStability is an equivalent of
adXactReadCommitted.
Therefore setting the isolation level to adXactCursorStability doesnot
really change it to
Informix cursor stability. It's still read committed.
Could you pls point out is there any way to set the isolation level to
Informix cursor stability?
Some backgrounds:
I have some concurrency problem using read committed as isolation
level.
They need to lock the row to read. Repeatable read is too aggresive.
Cursor stability will be ideal.
Thanks
<</QUATE>>
TIA.
--
Tsutomu Ogiwara from Japan
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.