Subject | Lock Timeout for WAIT Transactions |
---|---|
Author | Bryan Pendleton |
Post date | 2007-08-08T23:12:38Z |
Hi all,
I'm trying to understand the section in the 2.0.1 release
notes regarding "Lock Timeout for WAIT Transactions", and
I have two questions:
1) How do I know whether I have a WAIT transaction or not?
Is the transaction default WAIT? or NO WAIT? Is there an API
call that I make to specify that my transaction is WAIT?
2) What are the units for LOCK TIMEOUT? If I specify
SET TRANSACTION LOCK TIMEOUT 100, does that mean 100 seconds?
100 milliseconds? Some other unit?
thanks,
bryan
I'm trying to understand the section in the 2.0.1 release
notes regarding "Lock Timeout for WAIT Transactions", and
I have two questions:
1) How do I know whether I have a WAIT transaction or not?
Is the transaction default WAIT? or NO WAIT? Is there an API
call that I make to specify that my transaction is WAIT?
2) What are the units for LOCK TIMEOUT? If I specify
SET TRANSACTION LOCK TIMEOUT 100, does that mean 100 seconds?
100 milliseconds? Some other unit?
thanks,
bryan