Hi,

after I save an object and do transaction commit, the program hangs. Then restart the program does not work. I have to restart the os system to solve the problem.

Could anyone tell me what's wrong and how to solve this.

Thanks in advance.

Yulei

Not much information from the original issue.
What DB? OS? Can you show some code where you commit?

DB: oracle9
OS: windows2000

code:

NewObject o = new NewObject("a");

Session session = HibernateUtil.currentSession();

Transaction trans = session.createTransaction();

session.save(o);

trans.commit();

session.close().

And, those statements sometimes work well, and sometimes they hangs at trans.commit()

I do not think forum can help to debug this stuff without information, "Something sometimes hungs" is not a information to solve a problem. Try tools to debug application, JVM, DB, OS.

It seems that when I open an db tool(sybaseToad), and connect it to DB, then the program might hangs at trans.commit(). Sometimes when I exit the db tool, the programs can goes on. Could anyone tells me what's wrong? I can not prevent my application user to use a DB tool while running my application. What to do to solve this?

take this up w/ the sybaseToad vendor. sounds like it is not releasing a lock.

or force commit with your tool... learn how it works

which tool can i use to close the connection?