How To Pass oracle.jdbc.ReadTimeout To The JVM With JDBC To Avoid Hangs on SocketRead ?
(Doc ID 1535858.1)
Last updated on FEBRUARY 03, 2022
Applies to:JDBC - Version 10.2.0.1 to 126.96.36.199.0 [Release 10.2 to 12c]
Information in this document applies to any platform.
System property -Doracle.jdbc.ReadTimeout is set to configure Oracle JDBC driver 10g timeouts to avoid hangs on socketRead when there is a database outage or Network problem.
However, it is noticed that it does not take effect as per the thread dump:
<ExecuteThread: '61' for queue: '...' has been busy for "736" seconds
working on the request "weblogic.work.ExecuteRequestAdapter@2fcc33", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:
The expected result is:
java.sql.SQLException: Io exception: Socket read timed out
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document