Technical data

Configuring and Managing JDBC Connection Pools, MultiPools, and DataSources Us-
Administration Guide 16-25
Creating the JDBC Objects
Using the Administration Console, you create the JDBC components—Connection
Pools, Data Sources, and MultiPools—by specifying attributes and database
properties. See “Configuring JDBC Connectivity Using the Administration Console”
on page 16-27.
First you create the connection pool or MultiPool, then the Data Source. When you
create a Data Source object, you specify a connection pool or MultiPool as one of the
Data Source attributes. This permanently associates that Data Source with a specific
Connection Pool or MultiPool ("pool").
Assign the JDBC Objects
Once you configure the Data Source and associated Connection Pool (or MultiPool),
you then assign each object to the same servers or clusters. Some common scenarios
are as follows:
n In a cluster, assign the Data Source to the cluster, and assign the associated
Connection Pool to each managed server in the cluster.
n In a single server configuration, assign each Data Source and its associated
Connection Pool to the server.
n If you are using a MultiPool, assign the Connection Pools to the MultiPool; then
assign the Data Source and all Connection Pools and the MultiPool to the
server(s) or cluster(s).
See “Configuring JDBC Connectivity Using the Administration Console” on page
16-27 for a description of the tasks you perform.