Technical data

16 Managing JDBC Connectivity
16-28 Administration Guide
Database Passwords in Connection Pool Configuration
When you create a connection pool, you typically include at least one password to
connect to the database. If you use an open string to enable XA, you may use two
passwords. WebLogic Server includes the following fields on the JDBC Connection
Pool
→Configuration→General tab:
n Password. Use this field to set the database password. If set, this value overrides
any
password value defined in the Properties passed to the tier-2 JDBC
Driver when creating physical database connections. The value is encrypted in
the
config.xml file (stored as the Password attribute in the
JDBCConnectionPool tag) and is hidden on the administration console.
n Open String Password. Use this field to set the password in the open string
that the transaction manager in WebLogic Server uses to open a database
connection. If set, this value overrides any password defined as part of the open
string in the
Properties field. The value is encrypted in the config.xml file
(stored as the
XAPassword attribute in the JDBCConnectionPool tag) and is
hidden on the Administration Console. At runtime, WebLogic Server
reconstructs the open string with the password you specify in this field. The
open string in the Properties field should follow this format:
4 Configure a Data
Source (and
Associate with a
Pool)
Using the Data Source tab, set the attributes for the Data
Source, including the Name, JNDI Name, and Pool Name
(this associates, or assigns, the Data Source with a specific
pool—Connection Pool or MultiPool.)
5 Configure a Tx Data
Source (and
Associate with a
Connection Pool)
Using the Tx Data Source tab, set the attributes for the Tx
Data Source, including the Name, JNDI Name, and
Connection Pool Name (this associates, or assigns, the
Data Source with a specific pool).
6 Assign a Connection
Pool to the
Servers/Clusters
Using the Target tab, you assign the Connection Pool to
one or more Servers or Clusters. See Table 16-18
Association and Assigninment Scenarios.
7 Assign the MultiPool
to Servers or Clusters
Using the Target tab, you assign the configured MultiPool
to Servers or Clusters.
Table 16-19 JDBC Configuration Tasks
Task #
JDBC
Component/ Task
Description