Hello I' m following problem with my multithread application:
my app appears to be hanging or deadlocked trying to save or commit items to an Oracle DB. I' m start 5 threads to do some inserts. It don't hang always, only some time the call
dom4jSession.save(entity, rootNode); return not until 4 or 5 seconds!.
Name and version of the database you are using: Oracle10
Hibernate version: 3.1 final
Code between sessionFactory.openSession() and session.close():
Code:
session = sessionFactory.openSession();
tx = session.beginTransaction();
dom4jSession = session.getSession(EntityMode.DOM4J);
Node rootNode = document.getRootElement();
dom4jSession.save(entity, rootNode);
tx.commit();
session.close();