My Oracle Support Banner

JDBC Idle Connection Problems on IBM AIX Platform (Doc ID 472572.1)

Last updated on JULY 31, 2018

Applies to:

JDBC - Version 10.2.0 to 10.2.0.5
IBM AIX on POWER Systems (64-bit)


IBM AIX Based Systems (64-bit)
AIX5L Based Systems (64-bit)
AIX5L 5.2 / 5.3
JDK 1.4 / 1.5
RDBMS 10.2



Symptoms

A java program makes a JDBC connection to an Oracle Database.  After several hours of inactivity, the idle JDBC connection is dropped.  When accessing the idle JDBC connection, an error is reported.  The error can be different depending on the environment.  The errors reported can be:


The java program runs on a machine with AIX5L 5.2 or 5.3 operating system.  The idle JDBC connection is dropped after about 12 hours of inactivity.  The problem occurs with both JDBC OCI and JDBC Thin driver.

Changes

Using the Oracle JDBC 10.2 driver on IBM AIX5L platform.

Cause

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
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.