aspose file tools*
The moose likes JDBC 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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Timeout in Stored Procedure" Watch "Timeout in Stored Procedure" New topic
Author

Timeout in Stored Procedure

Raj Shan
Ranch Hand

Joined: Sep 04, 2006
Posts: 65
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