Connection Leak: Find LeakedConnectionException Reported in AOLJ Database Connection Pool Test (Doc ID 1177093.1)

Last updated on JULY 20, 2016

Applies to:

Oracle Application Object Library - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Oracle Applications E-Business Suite Release 12.


Symptoms

After running "AOL/J Database Connection Pool Test" you find many connection leaks reported as below:
oracle.apps.fnd.security.LeakedConnectionException 1, 0x1421fc8, 2010-05-17+14:09:23.745-0700,  
Thread[AJPRequestHandler-HTTPThreadGroup-12,5,HTTPThreadGroup]
at oracle.apps.fnd.security.CallStack.getInstance(CallStack.java:109)
at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:990)
at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:973)
at oracle.apps.fnd.common.Pool.costBasedSelection(Pool.java:1885)
at oracle.apps.fnd.common.Pool.selectObject(Pool.java:1686)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:950)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:584)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:330)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1719)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2314)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(

 

Changes

 

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