Java Stored Procedure Ignores Timeout Period Specified For Socket Connection On Database On Windows

(Doc ID 1335414.1)

Last updated on AUGUST 03, 2016

Applies to:

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


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 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.


Upgrade from database to


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