Hello.
I've noticed query timeout for Oracle connections is a stub, seems like OCI API does not provide a way to limit query execution out-of-box. Yet I am trying to workaround the blocked (server-side) connections issue with DBMail and setQueryTimeout() seems to be a good tool for that.
So far I came up with a thread-based solution: 1. a dedicated thread is created for every db connection; 2. thread acts like a watchdog: for every started query it counts down from TIMEOUT value to zero; 3. if query execution is finished the counter is reset and thread idles; 4. if counter reaches 0 the thread calls OCIBreak().
I'd like to know your vision on the solution and reasons why query timeouts are not implemented for Oracle backend before I start the development and publish the patch. TIA.