My Oracle Support Banner

WebLogic Server: Investigating Transaction Problems Support Pattern (Doc ID 1332274.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

Oracle WebLogic Server - Version 9.2 and later
Information in this document applies to any platform.

Purpose

This document discusses how to troubleshoot and fix issues involving JTA transactions.

Problem Description

Transactions are a central point in WebLogic Server that bring different systems and technologies together. Problems and misconfiguration in other systems such as databases may cause transaction coordination in WebLogic Server to fail.

This pattern gives some background information about the transaction subsystem of WebLogic Server (JTA, JTS). It also provides information on exceptions and errors that result from transaction problems. In addition, it gives information about transaction-related properties like timeouts as well as JDBCConnectionPool or DataSource properties that have an influence on the transactional behavior of WebLogic Server.

Troubleshooting Steps

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
Purpose
 Problem Description
Troubleshooting Steps
 Information about the WebLogic Server Transaction Subsystem
 Transactions in WebLogic Server
 Transactions and JDBC Connection Pool Wrappers
 Limitations of JTS Connection Wrappers in Distributed Transactions
 HeuristicMixedException due to XA resource problem at the time of commit
 Heuristic Commit Error at Time of Database Failure
 HeuristicMixedExceptions during Commit of Transactions
 After a Failure, Transactions Must be Abandoned During Recovery of Distributed Transactions Using a JTSConnection
 Support for Local Transactions Using an XA Driver
 WebLogic Server JTA Timeout and XA Resource Manager Timeout
 Possible Error Messages if using two different JDBCConnection Pools for the same Database (Oracle) or two DataSources for the same pool
 Heuristic Error Messages during WebLogic Server Commit Failed
 Background Information
 Transaction Timeout and Transaction Rollback in WebLogic Server
 Troubleshooting Transaction Problems by Setting Debug Flags
 WebLogic Server and Oracle RAC
 Oracle ORA-01591
 Related Reading
 Known Issues
 Need further help?
References

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