| Stale JDBC Connections [message #92229] |
Mon, 26 April 2004 12:33 |
RR
Messages: 19
Registered: October 2001
|
Junior Member |
|
|
In a JVM, JDBC Connections are acquired using the oci driver connecting to Oracle 9i Database.
The connections support extended transactions that needs atomicity i.e
1. Start Transaction
2. Read one row
3. Update one row
4. Delete another row
5. Commit Transaction.
Now in this workflow, if the JVM crashes at step 4.. How to recover. How to remove the ROW level lock acquired in step3.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
