3.4.3 Transaction types available for each resource

This subsection describes the transaction types available for the following resources:

The transaction types available for each resource are determined by the settings in the following items:

Transaction support levels specified for each resource adapter
Different transaction types are available for each of the following three transaction support levels:
  • NoTransaction
    The resource transactions are not managed.
  • LocalTransaction
    The resource transactions are managed using a local transaction.
  • XATransaction
    The resource transactions are managed using a global transaction.
Note that the settings for the transaction support levels are specified as the resource adapter properties. For details on the resource adapter settings, see 3.4.12 Settings in the execution environment.
Enabling and disabling of the light transaction functionality
The available transaction types differ based on whether the light transaction functionality is enabled or disabled.
Organization of this subsection
(1) For database connections
(2) For connecting to a database queue
(3) For OpenTP1 connections (Outbound connection)
(4) For OpenTP1 connections (Inbound connection)
(5) For CJMSP Broker connections
(6) For the other resources

(1) For database connections

The following table describes the transaction types determined by the mapping between the connection methods and transaction support levels.

Table 3-12 Available transaction types (for database connections)

Connection methodTransaction support levelLight transaction functionality
EnabledDisabled
DB Connector (DBConnector_HiRDB_Type4_CP.rar)
(DBConnector_Oracle_CP.rar)
(DBConnector_SQLServer_CP.rar)
(DBConnector_CP_ClusterPool_Root.rar)
(DBConnector_Oracle_CP_ClusterPool_Member.rar)
NoTransactionNoNo
LocalTransactionLocalLocal
DB Connector (DBConnector_HiRDB_Type4_XA.rar)
(DBConnector_Oracle_XA.rar)
XATransaction--Global
Legend:
Global: Global transaction
Local: Local transaction
No: Transactions are not managed
--: Cannot be specified

(2) For connecting to a database queue

The following table describes the transaction types determined by the mapping between the connection methods and transaction support levels.

Table 3-13 Available transaction types (for connecting to a database queue)

Connection methodTransaction support levelLight transaction functionality
EnabledDisabled
DB Connector for Cosminexus RM and Cosminexus RM
(DBConnector_HiRDB_Type4_CP_Cosminexus_RM.rar)
(DBConnector_Oracle_CP_Cosminexus_RM.rar)
NoTransactionNoNo
LocalTransactionLocalLocal
DB Connector for Cosminexus RM and Cosminexus RM (DBConnector_HiRDB_Type4_XA_Cosminexus_RM.rar)
(DBConnector_Oracle_XA_Cosminexus_RM.rar)
XATransaction--Global
Legend:
Global: Global transaction
Local: Local transaction
No: Transactions are not managed
--: Cannot be specified

(3) For OpenTP1 connections (Outbound connection)

The following table describes the transaction types determined by the mapping between the connection methods and transaction support levels.

Table 3-14 Available transaction types (For OpenTP1 connections (Outbound connection))

Connection methodTransaction support levelLight transaction functionality
EnabledDisabled
uCosminexus TP1 ConnectorNoTransactionNoNo
LocalTransactionLocalLocal
XATransaction--Global
TP1/Message Queue - AccessNoTransactionNoNo
LocalTransactionLocalLocal
XATransaction--Global
Legend:
Global: Global transaction
Local: Local transaction
No: Transactions are not managed
--: Cannot be specified

(4) For OpenTP1 connections (Inbound connection)

For details on the transaction types available for the TP1 inbound adapter, see 3.13.2 Functionality available for other resource connections.

(5) For CJMSP Broker connections

The following table describes the transaction types determined by the mapping between the connection methods and transaction support levels.

Table 3-15 Available transaction types (For CJMSP Broker connections)

Connection methodTransaction support levelLight transaction functionality
EnabledDisabled
CJMSP resource adapterNoTransactionNoNo
LocalTransactionLocalLocal
XATransaction----
Legend:
Local: Local transaction
No: Transactions are not managed
--: Cannot be specified

(6) For the other resources

For details on the transaction types available for the resource adapters conforming to the Connector 1.5 specifications, see 3.13.2 Functionality available for other resource connections.