Hibernate version:2.1.7
Name and version of the database you are using: oracle 9
I'm locking an object via:
Code:
session = factory.openSession();
mutex = session.get(..., LockMode.UPGRADE);
tx = session.beginTransaction();
...
tx.commit();
session.flush();
session.lock(mutex, LockMode.NONE);
session.close();
The factory continues to live, so does the jdbc connection (as intended) but on the oracle enterprise manager I can see that the row is still locked, thus when trying to lock it from another JVM the lock just hangs there.
How can I unlock the object (without shutting down the jdbc connection)?
Thanks
G.