XA datasources with #WebSphere and #Oracle

By | November 14, 2017

When using XA data sources with Websphere and Oracle we must grant to the Oracle user rights to perform XA recovery.

STEP 1: Create an XA datasource

STEP 2: Grant right to the oracle user (MY_USER).

As sysdba execute the following:

Grant access to pending transactions.

Grant access rights to distributed transactions awaiting recovery.

Grant access to unresolved transactions (either due to failure or if the coordinator has not sent a commit/rollback).

Grant execute rights to be able to execute transaction rool-back.

If you are using an Oracle 10.2.0.3 or lower JDBC driver, execute instead the following statement:

Contribute to this site maintenance !

This is a self hosted site, on own hardware and Internet connection. The old, down to earth way 🙂. If you think that you found something useful here please contribute. Choose the form below (default 1 EUR) or donate using Bitcoin (default 0.0001 BTC) using the QR code. Thank you !

€1,00

Advertisements

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.