How To Pass oracle.jdbc.ReadTimeout To The JVM With JDBC?
Last updated on NOVEMBER 22, 2017
Applies to:JDBC - Version 10.2.0.1 to 220.127.116.11.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 database outage or Network problem.
However, it is noticed that it does not take effect as per the thread dump:
<ExecuteThread: '61' for queue: 'wm/crmWorkMgr' has been busy for "736" seconds
working on the request "weblogic.work.ExecuteRequestAdapter@2fcc33", which is more than the configured time (StuckThreadMaxTime) of "6
00" seconds. Stack trace:
instead of expected result:
java.sql.SQLException: Io exception: Socket read timed out
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms