ORACLE.NET.READ_TIMEOUT Property Does Not Work On 11g JDBC Driver (Doc ID 1341966.1)

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version 10.1.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Mar-2013***

Symptoms

There is a requirement to set a timeout on Socket level for the jdbc thin driver.  This was done by specifying oracle.net.READ_TIMEOUT, but this is not working anymore in JDBC 11.1 or higher.

for example:

Properties prop = new Properties ();
prop.put ("user", "user_name");
prop.put ("password", "write_password");
prop.put ("oracle.net.READ_TIMEOUT", "180000"); // timeout in ms
conn = DriverManager.getConnection (url, prop);

Changes

upgrade of jdbc driver to 11.1 or higher

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms