a0b4b3a0_great_grandson_of_Husnu_Sensoy__Classical_Optimistic_Locking
[0] Persistent physical database connection is required [Pessimistic Locking] Yes [Description] In optimistic locking we simulate the physical connection as a logical one but in pessimistic locking we need to keep database connection opened. This is the fundamental reason making optimistic locking suitable for 3-tier architecture. [Classical Optimistic Locking] 
No
H a r d e r
M o r e e x p e n s i v e
U s u a l l y m o r e c o m p l e x
N o
3 - t i e r a r c h i t e c t u r e
L o w e r
Y e s
A Locking Mechanism in Oracle 10g for Web Applications | The great grandson of Husnu Sensoy
Classical Optimistic Locking