My Oracle Support Banner

Deadlock When Using The Implicit Connection Cache Timetolive or Abandon Timeout (Doc ID 402788.1)

Last updated on AUGUST 30, 2023

Applies to:

JDBC - Version to [Release 10.1 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.


An application is retrieving connection from the 10g Oracle JDBC  Implicit Connection Cache (ICC). The application hang can happen when the  ICC abandon or timetolive timeout are enabled;

A deadlock is occurring when at the same time:

To illustrate this situation, here are the Java Stack dump of those threads [ Thread-11 is the ICC internal JDBC thread and Thread 14 is the application thread. (closing the connection)] :

at oracle.jdbc.pool.OracleImplicitConnectionCache.reusePooledConnection(
- waiting to lock <0x10969fe0> (a oracle.jdbc.pool.OracleImplicitConnectionCache)
at oracle.jdbc.pool.OracleConnectionCacheEventListener.connectionClosed(
- locked <0x109ad220> (a oracle.jdbc.pool.OracleConnectionCacheEventListener)
at oracle.jdbc.pool.OraclePooledConnection.callImplicitCacheListener(
at oracle.jdbc.pool.OraclePooledConnection.logicalCloseForImplicitConnectionCache(
at oracle.jdbc.pool.OraclePooledConnection.logicalClose(
at oracle.jdbc.driver.LogicalConnection.closeInternal(
at oracle.jdbc.driver.LogicalConnection.close(
- locked <0x109ad240> (a oracle.jdbc.driver.LogicalConnection)  at test.TestPool$

at oracle.jdbc.driver.LogicalConnection.close(
- waiting to lock <0x109ad240> (a oracle.jdbc.driver.LogicalConnection)
at oracle.jdbc.pool.OracleImplicitConnectionCache.closeCheckedOutConnection(
at oracle.jdbc.pool.OracleImplicitConnectionCacheThread.runTimeToLiveTimeout(
- locked <0x10969fe0> (a oracle.jdbc.pool.OracleImplicitConnectionCache)
at )

Found 1 deadlock.





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

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