Hibernate Books

All times are UTC - 5 hours [ DST ]



Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Transaction Timeout not happening with Oracle 11 G
PostPosted: Fri Mar 23, 2012 12:00 pm 
Newbie

Joined: Wed Mar 21, 2012 9:28 am
Posts: 2
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


Top
 Profile  
 
 Post subject: Re: Transaction Timeout not happening with Oracle 11 G
PostPosted: Wed Apr 18, 2012 3:43 am 
Newbie

Joined: Tue Apr 17, 2012 5:58 am
Posts: 5
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 :)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.