Home » Developer & Programmer » JDeveloper, Java & XML » Stale JDBC Connections
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.
Previous Topic: Deploying to OC4J 1.0.2.2.1 inside Oracle9iAS 1.0.2.2.2
Next Topic: How do I pass Oracle sysdate to a Java stored procedure
Goto Forum:
  


Current Time: Tue Jul 27 22:57:29 CDT 2021