Administration and Configuration for WebLogic JDBC

 

This section provides an overview of the JDBC administrative tasks related to BEA WebLogic Server.

• Configuring JDBC

• Monitoring JDBC Connectivity

For additional information, see

• Managing JDBC Connectivity in the Administration Guide. Describes how to use the Administration Console and command-line interface to configure and manage connectivity.

• Administration Console Online Help. Describes how to use the Administration Console to set specific configuration tasks.

• Configuring WebLogic JDBC Features. Describes how to use the JDBC API to configure connectivity.

 

---

Configuring JDBC

The WebLogic Console provides the interface you use to enable, configure, and monitor features of the WebLogic Server, including JDBC. To invoke the Administration Console, refer to the procedures described in Configuring WebLogic Servers and Clusters in the Administration Guide. The attributes define the JDBC environment that includes:

• Connection Pools

• MultiPools

• DataSources

Configuring Connection Pools

You use the Administration Console to configure a connection pool, which includes defining the attributes and connection parameters, cloning pools, and assigning connection pools to a server or domain. For more information regarding connection pools, see Using Connection Pools and for configuring for database connectivity, see Managing JDBC Connectivity in the Administration Guide.

Configuring MultiPools

You define, or name, a MultiPool in the Administration Console and then determine which of the previously defined connection pools will constitute a specific MultiPool. All of the connections in a particular connection pool are identical, that is, they are attached to a single database with the same user, password and connection properties. With MultiPools, however, the connection pools within a MultiPool may be associated with different DBMSs. You have the option of setting the search methodology by selecting either the load balancing or the high availability algorithm behavior.

For more information regarding uses for MultiPools, see Using MultiPools and for configuring for database connectivity, see Managing JDBC Connectivity in the Administration Guide.

Configuring DataSources and TxDataSources

As with Connection Pools and MultiPools, you create the DataSource objects in the Administration Console. Data Source objects can be defined with (TxDataSource) or without (DataSource) transaction services. You configure Connection Pools and MultiPools before you define the DataSource pool name attribute. For DataSource objects in local and distributed transactions, see Managing JDBC Connectivity in the Administration Guide and Configuring WebLogic JDBC Features.

 

---

Monitoring JDBC Connectivity

The Administration Console provides tables and statistics to enable monitoring the connectivity parameters for each of the subcomponents—Connection Pools, MultiPools, DataSources, and TxDataSources.

You can also access statistics for connection pools programmatically through the JDBCConnectionPoolRuntimeMBean; see WebLogic Server Partner's Guide and the WebLogic Javadoc. This MBean is the same API that populates the statistics in the Administration Console. Read more about monitoring connectivity in the Monitoring a WebLogic Domain and Managing JDBC Connectivity sections of the Administration Guide.

For information about using MBeans, see Programming WebLogic JMX Services.