Oracle 10.2 - Connection Lock
ODBI=2 (READ_COMMITTED)
LockTimeout=2 (ORAODBC.INI)
WITH_KEY IO access
Step | Action (User) | IO$STS | Message | 1 | Insert (1) | OK | IO Operation Succeeded | 2 | Insert (2) | ER | Record Locked | 3 | Delete (2) | NR | Record not found | 4 | Commit (1) |
|
| 5 | Update (1) | OK | IO Operation Succeeded | 6 | Update (2) | ER | Record Locked | 7 | Fetch (1) | OK | IO Operation Succeeded | 8 | Fetch (2) | OK | IO Operation Succeeded | 9 | Commit (1) |
|
| 10 | Delete (1) | OK | IO Operation Succeeded | 11 | Insert (2) | ER | Record Locked | 12 | Update (2), Delete (2) | ER | Record Locked | 13 | Commit (1) |
|
| |
Note the differences between Oracle and SQL Server at steps 3 and 8.
Last Record Read IO access
This is a different set of steps as there must be a record to read before the last record read can be updated or deleted! Hence when an error occurs, the record must be fetched again like in Step 13.
Step | Action (User) | IO$STS | Message | 1 | Insert (1) | OK | IO Operation Succeeded | 2 | Insert (2) | ER | Record Locked | 3 | Commit (1) |
|
| 4 | Fetch (1), Fetch (2) | OK | IO Operation Succeeded | 5 | Update (1) | OK | IO Operation Succeeded | 6 | Update (2) | ER | Record Locked | 7 | Fetch (1) | OK | IO Operation Succeeded | 8 | Fetch (2) | OK | IO Operation Succeeded | 9 | Commit (1) |
|
| 10 | Fetch (1), Fetch (2) | OK | IO Operation Succeeded | 11 | Delete (1) | OK | IO Operation Succeeded | 12 | Insert (2) | ER | Record Locked | 13 | Fetch (2) Update (2), Fetch (2) Delete (2) | ER | Record Locked | 14 | Commit (1) |
|
| |