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.
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?