SOA Database Connectivity Issues Showing DatabaseException Internal Exception: java.sql.SQLException (Doc ID 1309181.1)

Last updated on APRIL 07, 2017

Applies to:

Oracle SOA Suite - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When running SOA composites and applications you are getting multiple errors of the following type

ERROR 1
-----------
[TopLink Warning]: 2011.02.19 10:19:56.413--UnitOfWork(1606199273)--Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.3.0) (Build 100323)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMERR start() failed on resource 'SOADataSource_SOA': XAER_RMERR : A resource manager error has occured in the transaction branch
javax.transaction.xa.XAException: Unexpected error during start for XAResource 'SOADataSource': Transaction timed out after 31 seconds
BEA1-25400F2F5B819CA4ECC4
at weblogic.jdbc.wrapper.XA.createException(XA.java:103)
at weblogic.jdbc.jta.DataSource.start(DataSource.java:785)
at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1228)
at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1161)
at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:282)
at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:507)
at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:434)
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1592)


The above error might be followed by the following by the error message saying that "Connection has been administratively disabled".

ERROR 2
-----------
java.sql.SQLException: Connection has been administratively disabled. Try later.
at weblogic.jdbc.common.internal.ConnectionEnv.checkIfEnabled(ConnectionEnv.java:895)
at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:58)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:93)
at weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection.getAutoCommit(Unknown Source)
at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler
   .setAutoCommit(AttributeRestoringConnectionInvocationHandler.java:83)
at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler
   .invoke(AttributeRestoringConnectionInvocationHandler.java:65)
at $Proxy300.setAutoCommit(Unknown Source)
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:191)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3750)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2720)
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)

 

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