Hi,

We have a could like below to set transaction timeout. This is not working with Oracle 11 G (with ojdbc6.jar)

Transaction tx = getSession().getTransaction();
tx.setTimeout(txnTimeout);
tx.begin();

If we update a row through hibernate and that row is already locked (say through a SQL workbench), the process does not time out it goes on. our time out was 180 seconds, but its waiting endlessly. Any pointers why this could be happening?

Thanks in advance

hi saurabhchandra,

have you found a solution to your problem? i have the same issue here with query execution timeout, however i use entity manager factory not session factory

thnx :)