*
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?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Timeout in Stored Procedure
 
Similar Threads
setQuerytimeout in CallableStatement not working. Kindly please help
Query Timeout
Help needed: using setQueryTimeout() on prepared statement
JT400 and commitment control
JDBC to DB2 Mainframe - query timeout