Data Source Configuration – Non-XA Datasource with JTA Support

These are the datasources ending with _GTXN, used in a OLTP flow. These configuration enable the XA feature on the connection only when multiple resources are involved in a transaction, thereby eliminating the XA overhead in cases where a simple connection is sufficient.
Section Parameter Name Value Description
Transaction Supports Global Transaction Check Connections from this pool will be managed by Weblogic Transaction Manager (JTA) when this is enabled.
Transaction Logging Last Resource Select This is an efficient option to enabled XA behavior on this connection when multiple resources are involved in a transaction. This connection will be the last one to get committed in a transaction.
Connection Pool Inactive Connection Timeout 0 Disable the connection recovery at pool level. JTA timeout will control this.