Last updated on DECEMBER 07, 2016
Applies to:Oracle WebLogic Server - Version 10.3 and later
Information in this document applies to any platform.
***Checked for relevance on 6-Jul-2015***
This issue occurred in a WebLogic Server (WLS) 10.3.5 domain with an Admin server and three managed servers all residing on same physical machine. Over a period of several weeks, one of the managed servers threw the following data source exceptions, and the transactions were rolled back. A whole server restart was required to restore the services.
The JDBC data source cannot be configured for transactions, but will support the Java Transaction API (JTA) with Java Messaging System (JMS). See "Handling JMS Transactions with JDBC Stores".
Also, see "Creating a JDBC Store" where it states:
Note: You cannot specify a JDBC data source that is configured to support global (XA) transactions. Therefore, the specified JDBC data source must use a non-XA JDBC driver. In addition, you cannot enable Logging Last Resource or Emulate Two-Phase Commit in the data source. This limitation does not remove the XA capabilities of layered subsystems that use JDBC stores. For example, WebLogic JMS is fully XA-capable regardless of whether it uses a file store or any JDBC store.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms