File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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

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
 
Similar Threads
Help needed: using setQueryTimeout() on prepared statement
JDBC to DB2 Mainframe - query timeout
Query Timeout
JT400 and commitment control
setQuerytimeout in CallableStatement not working. Kindly please help