The solution to this problem involves applying patches to
both Oracle and WebSphere:
For Oracle:
Oracle must be at least the 8.1.7.4 or 9.2.0.2 level and patch 2511780
(obtained from Oracle Corporation) must be applied. If a higher version of
Oracle is used, you should verify with Oracle whether or not patch 2511780
is included.
For WebSphere:
For WebSphere, the Cumulative CM (Connection Manager) Interim Fix,
dated 03-26-2003 or later, must be applied and a data source custom
property called "transactionBranchesLooselyCoupled" must be set to
"true"

When the WebSphere interim fix is applied and the custom property
transactionBranchesLooselyCoupled is set correctly, the following message
appears in the Application Server stdout:
CMXAResourceI W CONM6021W A Oracle JDBC provider property
(TransactionLooselyCoupled) has been set. Oracle patch 2511780 must be
applied before setting this property.
This message will appear even if patch 2511780 is applied. If it is
applied, the message can be ignored. With the patch applied and
transactionBranchesLooselyCoupled set to true, the problem should be
resolved.
|