Java Stored Procedure Ignores Timeout Period Specified For Socket Connection On 11.2.0.2 Database On Windows (Doc ID 1335414.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 to 11.2.0.2 - Release: 11.2 to 11.2
Microsoft Windows x64 (64-bit) - Version: 2008 R2

Symptoms


A java stored procedure ignores the timeout period set on a socket and times
out after the default TCP timeout setting on the operating system. The
problem reproduces only on 11.2.0.2 database on Windows platform. If a
Timeout of 4 seconds is used in the following code, this will not be honoured
and the socket will timeout only after 21 seconds (default tcp timeout on
Windows 2008).

InetSocketAddress sockAddr = new InetSocketAddress(IPAddress, IPPort);
Socket s = new Socket();
s.connect(sockAddr, Timeout);

The problem does not reproduce on Linux. Also a standalone java program
works fine on both Linux and Windows.

Changes

Upgrade from database 11.2.0.1 to 11.2.0.2

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