This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Timeout in Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Timeout in Stored Procedure" Watch "Timeout in Stored Procedure" New topic
Author

Timeout in Stored Procedure

Geetha Gubendran
Ranch Hand

Joined: Sep 04, 2006
Posts: 75
In Message broker, from Java compute node, I am calling a oracle stored procedure using callable statement. In that I am setting the timeout using setQueryTimeout(). But setQueryTimeout() has some issues when the database server is hung or when there are network issues. I am calling the stored procedure using conDb.prepareCall(). I want to know what are the other ways of cancelling the stored proc execution and getting the control back to Java compute node? Can someone help me out with this request?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Timeout in Stored Procedure
 
It's not a secret anymore!