While Running SDK Application, Connection Fails Intermittently Due to JDBC Connection Pool Limit Reached (Doc ID 1265537.1)

Last updated on JANUARY 01, 2024

Applies to:

Symptoms

SDK based Custom Report fails intermittently.

Custom SDK application incurs many transactions and is run frequently.

Error in the weblogic logs:

####<Sep 13, 2010 12:32:34 PM PDT> <Notice> <EJB> <server name> <server name> <[ACTIVE] ExecuteThread: '23' for queue: 'weblogic.kernel.Default (self-tuning)'> <zk2admin> <> <> <1284406354504> <BEA-010014> <Error occurred while attempting to rollback transaction: javax.transaction.SystemException: Heuristic hazard: (weblogic.jdbc.wrapper.JTSXAResourceImpl, HeuristicHazard, (javax.transaction.xa.XAException: Closed Connection))
javax.transaction.SystemException: Heuristic hazard: (weblogic.jdbc.wrapper.JTSXAResourceImpl, HeuristicHazard, (javax.transaction.xa.XAException: Closed Connection))
at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:413)
at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:378)
at weblogic.ejb.container.internal.BaseRemoteObject.handleSystemException(BaseRemoteObject.java:854)
at weblogic.ejb.container.internal.BaseRemoteObject.handleSystemException(BaseRemoteObject.java:809)
at weblogic.ejb.container.internal.BaseRemoteObject.postInvoke1(BaseRemoteObject.java:514)
at weblogic.ejb.container.internal.StatelessRemoteObject.postInvoke1(StatelessRemoteObject.java:60)
at weblogic.ejb.container.internal.BaseRemoteObject.postInvokeTxRetry(BaseRemoteObject.java:441)
at com.agile.pc.cmserver.pcmhelper.PCMHelperSessionBean_9xz6y2_EOImpl.logout(PCMHelperSessionBean_9xz6y2_EOImpl.java:1606)
at com.agile.pc.cmserver.pcmhelper.PCMHelperSessionBean_9xz6y2_EOImpl_WLSkel.invoke(Unknown Source)
[...]

Changes

Cause

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