Javax.transaction.xa.XAException: JDBC Driver Does Not Support XA For OraSDPMDataSource (Doc ID 2762775.1)

Last updated on JANUARY 08, 2024

Applies to:

Symptoms

On : 12.2.1.4.0 version, Product Installation

When attempting to change OIM DB OS from AIX to Linux.
the following error occurs.

ERROR
-----------------------
weblogic.transaction.RollbackException: Could not prepare resource 'OraSDPMDataSource_oim_domain
JDBC driver does not support XA, hence cannot be a participant in two-phase commit. To force this participation, set the GlobalTransactionsProtocol attribute to LoggingLastResource (recommended) or EmulateTwoPhaseCommit for the Data Source = OraSDPMDataSource
at weblogic.transaction.internal.TransactionImpl.throwRollbackException(TransactionImpl.java:2122)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:384)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:270)
at weblogic.transaction.internal.TransactionManagerImpl.commit(TransactionManagerImpl.java:389)
at weblogic.transaction.internal.TransactionManagerImpl.commit(TransactionManagerImpl.java:383)
at oracle.sdpinternal.messaging.jms.QueueWorker.commitUserTransaction(QueueWorker.java:183)
at oracle.sdpinternal.messaging.jms.QueueWorker.doWork(QueueWorker.java:112)
at oracle.sdpinternal.messaging.jms.QueueWorker.timerExpired(QueueWorker.java:70)
at weblogic.timers.internal.commonj.ListenerWrap.timerExpired(ListenerWrap.java:37)
at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:301)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:681)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused By: javax.transaction.xa.XAException: JDBC driver does not support XA, hence cannot be a participant in two-phase commit. To force this participation, set the GlobalTransactionsProtocol attribute to LoggingLastResource (recommended) or EmulateTwoPhaseCommit for the Data Source = OraSDPMDataSource
at weblogic.jdbc.wrapper.JTSXAResourceImpl.prepare(JTSXAResourceImpl.java:98)
at weblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerResourceInfo.java:1558)
at weblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerResourceInfo.java:528)
at weblogic.transaction.internal.ServerSCInfo$1.run(ServerSCInfo.java:412)
at weblogic.transaction.internal.ServerSCInfo.startPrepare(ServerSCInfo.java:423)
at weblogic.transaction.internal.ServerTransactionImpl.localPrepare(ServerTransactionImpl.java:3143)
at weblogic.transaction.internal.ServerTransactionImpl.globalPrepare(ServerTransactionImpl.java:2648)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:310)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:270)
at weblogic.transaction.internal.TransactionManagerImpl.commit(TransactionManagerImpl.java:389)
at weblogic.transaction.internal.TransactionManagerImpl.commit(TransactionManagerImpl.java:383)
at oracle.sdpinternal.messaging.jms.QueueWorker.commitUserTransaction(QueueWorker.java:183)
at oracle.sdpinternal.messaging.jms.QueueWorker.doWork(QueueWorker.java:112)
at oracle.sdpinternal.messaging.jms.QueueWorker.timerExpired(QueueWorker.java:70)
at weblogic.timers.internal.commonj.ListenerWrap.timerExpired(ListenerWrap.java:37)
at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:301)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:681)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)

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.