Technical data

JDBC Configuration Guidelines for Connection Pools, MultiPools and DataSources
Administration Guide 16-7
JDBC Configuration Guidelines for
Connection Pools, MultiPools and
DataSources
This section describes JDBC configuration guidelines for local and distributed
transactions.
Overview of JDBC Configuration
To set up JDBC connectivity, you configure Connection Pools, Data Source objects
(always recommended, but optional in some cases), and MultiPools (optional) by
defining attributes in the Administration Console and, for dynamic connection pools,
at the command line. There are three types of transactions:
n Local—non-distributed transaction
n Distributed with XA Driver—two-phase commit
n Distributed with non-XA Driver—single resource manager and single database
instance