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
JavaRanch » Java Forums » Databases » JDBC
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: 72
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