My Oracle Support Banner

E1: JAS: Inactive Database Sessions are not Closed when USEORACLEDBCONNECTIONPOOL=TRUE (Doc ID 2872267.1)

Last updated on MAY 23, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Even after user sign-out of JDE, there are inactive database sessions opened in the database for a far longer duration ( greater than connectionTimeout value plus the cleanPoolInterval value.)
The connections are cleared from the JAS session, connections are only left open from the database side.

Steps to replicate:

  1. Log in JDE and use one interactive application.
  2. Log out from JDE
  3. Check after time inteval greater than connectionTimeout + cleanPoolInterval
  4. Sessions on database level are still opened

Changes

Upgrade Tools Release to 9.2.6.X

Set USEORACLEDBCONNECTIONPOOL=TRUE

 

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
References


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