Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to specify time out for a query

 
giang nguyen
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I've blending my mind with how to specify the time out for a select query. Some time, because of problem in DB server, the SQLQuery keep hanging without throwing any SQLException. This result in user having to wait an infinite amount of time.
Does any of you have any idea on how make JDBC queries time-out aware ? or in general how to make a method calling a time-out based operation ?
Thanks a lot.
 
eammon bannon
Ranch Hand
Posts: 140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could wrap the JDBC call in a UserTransaction and call setTransactionTimeout. But I'd be looking at the DB and sort out whatever problem is the cause. DBs should not just hang.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic