Hello there, I use a callable statement that executes a Stored Procedure (Oracle), due to some logical bug, this stored proc is not returning (but just looping infinitely). How do I control this time-out? I am not using a fixed connection created from DriverManager (instead of obtaining one from conn pool, due to architectual issues).
Well, I do want the pl/sql developer to fix the bug. But lets say its not an infinite loop, but it takes an hour. Should my JDBC call just hang on to it helpless. In such case, wouldn't some JVM Thread monitor thinks its a hung thread and kill it? So I am wondering if I can handle this at Java layer.