This subsection describes the necessary settings of the database when using Oracle JDBC Thin Driver. For details, see Oracle manual.

When you are using a global transaction for connecting to Oracle, the user connecting to Oracle must be granted permission for executing the transaction recovery.

Permissions to be given

• SELECT permission of SYS.DBA_PENDING_TRANSACTIONS
• FORCE ANY TRANSACTION permission
• Permission to EXECUTE the SYS.DBMS_SYSTEM

For details on how to give permission, see Oracle manual.

Setting access permission for dynamic performance view

User connecting to Oracle must have permission to access the dynamic performance view. Set the permission to access the dynamic performance view for the users connecting to Oracle with one of the following methods:

• Run GRANT SELECT_CATALOG_ROLE TO User name;
• Run GRANT SELECT ON V_$INSTANCE TO User name; ,GRANT SELECT ON V_$PROCESS TO User name; and GRANT SELECT ON V_$SESSION TO User name;

Setting Timeout

Set in the DISTRIBUTED_LOCK_TIMEOUT parameter of the Oracle Server definition.

Note that other than the DISTRIBUTED_LOCK_TIMEOUT parameter, settings of the SesTmm parameter of XAOpenString affect the timeout; however, this parameter cannot be tuned.

For details, see the following subsections or manuals:

• 8.6.6 Setting a timeout in the database in the uCosminexus Application Server System Design Guide
• 8.6.8 Tuning parameter to set a timeout in the uCosminexus Application Server System Design Guide
• Oracle manual