The Adobe Customer Experience solution “Customer Communications – Interactive Statements” (formerly Interactive Statements Solution Accelerator) requires an XA-type JDBC data source. If the RDBMS being used is Oracle 11g, the user that connects to Oracle on behalf of the J2EE appserver JDBC connection pool requires additional “object privileges” to certain SYSTEM tables in Oracle. Essentially, these are as follows:
– SELECT object privileges on tables sys.dba_pending_transactions, sys.pending_trans$ and sys.dba_2pc_pending
– EXECUTE object privileges on table sys.dbms_xa
The required DDL is available in the ADEP install documentation here.
If this is not done, you will get WARNING messages in your appserver log that looks something like this:
WARN [loggerI18N] [com.arjuna.ats.internal.jta.recovery.xarecovery1] Local XARecoveryModule.xaRecovery got XA exception javax.transacti
See here for SQL Server 2008.
Original article at http://blogs.adobe.com/ADEP/2011/08/enabling-xa-transactions-in-oracle-11g-for-adep-interactive-statements.html.