Oracle and RepeatableRead transaction

Thread View: borland.public.delphi.database.bdp

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by john Tue, 16 Jan 2007 16:43

#23

Author: john
Date: Tue, 16 Jan 2007 16:43

9 lines
1278 bytes

.Net v1.1, BDP 2.5

Im trying to use the RepeatableRead transaction isolation level with an 
Oracle db. It doesnt seem to work right. If I select a row inside my 
transaction, another user should not be able to update that row until I end 
the transaction, right?
But this isn't the case. Is this a 'feature' of Oracle, or BDP problem?

thx

Re: Oracle and RepeatableRead transaction

#24

Author: john
Date: Tue, 16 Jan 2007 18:07

17 lines
1472 bytes

...nvrmind, I think this is a feature of Oracle. I can use SELECT FOR UPDATE 
to get the effect I want.



"john" <someone@no.no> wrote in message 
news:45ad0087$1@newsgroups.borland.com...
> .Net v1.1, BDP 2.5
>
> Im trying to use the RepeatableRead transaction isolation level with an 
> Oracle db. It doesnt seem to work right. If I select a row inside my 
> transaction, another user should not be able to update that row until I 
> end the transaction, right?
> But this isn't the case. Is this a 'feature' of Oracle, or BDP problem?
>
> thx
>

Re: Oracle and RepeatableRead transaction

#34

Author: Mark Tiede
Date: Tue, 06 Feb 2007 15:18

9 lines
1376 bytes

John,

   I THINK if you specify transactionisolationlevel of Serializable, you 
would also get what you want.  Exactly how to do that, I don't know, but I 
think you can.  I think you specify it in the connection string and that 
will override any other specification of isolationlevel, but I'm not sure. 
I haven't tracked that down myself yet...

   But with our products, that is what I did in the ADO/VCL world.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads