My Oracle Support Banner

Investigating Transaction Problems Support Pattern (Doc ID 779556.1)

Last updated on APRIL 15, 2024

Applies to:

Oracle WebLogic Server - Version 6.1 to 8.1
Information in this document applies to any platform.

Goal

Reference for troubleshooting WebLogic Server WLS Support Patterns reference <Note 1189504.1>  Primary Note on Oracle WebLogic Server JTA/JTS/Transaction Support Patterns

This document discusses how to troubleshoot and fix issues involving JTA transactions. Please note that this article discusses older versions of WLS: 6.1 to 8.1. For discussion of WLS 9.2.x and higher, please see the updated version of this support pattern at WebLogic Server: Investigating Transaction Problems Support Pattern <Note 1332274.1>.

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.

Solution

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
Goal
Solution
 Troubleshooting Steps
 Information about the WebLogic Server Transaction Subsystem
 Transactions in the WebLogic Server
 Transactions and JDBC Connection Pool Wrappers
 Limitations of JTS Connection Wrappers in Distributed Transactions
 HeuristicMixedException after a database restart or crash
 HeuristicMixedExceptions during commit of transactions in a cluster
 Heuristic Hazard error messages 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
 Inter-domain Transactions
 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 Recovery
 Background Information
 Transaction Timeout and Transaction Rollback in WebLogic Server
 Troubleshooting Transaction Problems by Setting Debug Flags
 Protocol Errors in a Distributed Transaction
 WebLogic Server and Oracle RAC/TAF
 Oracle ORA-01591
 Related Reading
 Known Issues
References

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