My Oracle Support Banner

How can a persistent Store use an XA Driver ? (Doc ID 2260600.1)

Last updated on MARCH 04, 2019

Applies to:

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

Goal

In this example, we see a JDBC Store, but in which the DS definition looks like the following:

<jdbc-driver-params>
<url>jdbc:oracle:thin:@(DESCRIPTION_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)(DESCRIPTION=(CONNECT_TIMEOUT=10)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=HOSTNAME1)(PORT=PORT)))(CONNECT_DATA=(SERVICE_NAME=HOSTNAME3)))(DESCRIPTION=(CONNECT_TIMEOUT=10)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=HOSTNAME2)(PORT=PORT)))(CONNECT_DATA=(SERVICE_NAME=HOSTNAME4))))</url>
<driver-name>oracle.jdbc.xa.client.OracleXADataSource</driver-name>
<properties>
<property>
<name>user</name>
<value>jms_owner</value>
</property>
<property>
<name>oracle.jdbc.ReadTimeout</name>
<sys-prop-value>300000</sys-prop-value>
</property>
<property>
<name>oracle.net.CONNECT_TIMEOUT</name>
<sys-prop-value>10000</sys-prop-value>
</property>
</properties>
<password-encrypted>ENCRYPTED_PASSWORD</password-encrypted>
</jdbc-driver-params>

 

The question here is:  How can a persistent Store use an XA Driver ? Normally such a definition would be considered to violate Oracle documentation as per https://docs.oracle.com/cd/E17904_01/web.1111/e13701/store.htm#CNFGD243
 

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
References


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