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

Last updated on AUGUST 16, 2016

Applies to:

JDBC - Version 10.2.0 to 10.2.0.5
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 03-Feb-2011***
***Checked for relevance on 15-Jan-2014***

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

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