Guest_imported
New member
- Jan 1, 1970
- 0
Hi,
please let me know the following
1) If we have a select statement as
case1 select empno from employee for update
case2 select empno from employee
case3 select empno from employee for fetch only
what is the type of lock used in case1 and what is the type of lock
used for case2. Is case2 uses share lock and case1 uses exclusive lock
2) If we use DB2 and websphere with update queries It is said that we must use TX_REPEATABLE_READ to maintain locks across load and store when using entity beans . Is that true? why is it so? any links to refer
regards
please let me know the following
1) If we have a select statement as
case1 select empno from employee for update
case2 select empno from employee
case3 select empno from employee for fetch only
what is the type of lock used in case1 and what is the type of lock
used for case2. Is case2 uses share lock and case1 uses exclusive lock
2) If we use DB2 and websphere with update queries It is said that we must use TX_REPEATABLE_READ to maintain locks across load and store when using entity beans . Is that true? why is it so? any links to refer
regards