I am using oracle jdbc driver 18.104.22.168 againt 11.1.07 database. With a simple java code we create a stored proc that does a sleep of 30secs and I execute a statement with setQueryTimeOut to timeout after 15 secs. The box I am executing is on a VM (redhat linux) and the database is on a AIX server. What happens is that the setQueryTimeout issues the SQLTimeoutException but the code finishes only after 30 secs (i.e. the elapsed time is after the sleep is finished). The behaviour is the same if I use 22.214.171.124 jdbc driver and looks like the session still is not closed even after the timeout period.
Please any ideas welcome.