Administration and Configuration for WebLogic JDBC

 

This topic includes the following sections:

• Configuring JDBC

• Monitoring JDBC Connectivity

This section provides an overview of the JDBC administrative tasks related to BEA WebLogic Server. For general information on configuration tasks, see Managing JDBC Connectivity in the Administration Guide. For information on specific configuration attributes and procedures, see the JDBC topic in WebLogic Console Online Help.

Before attempting to configure any JDBC drivers, be sure that the JDBC driver classes or zip files are in the WebLogic Server classpath for those drivers.

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 Configuring WebLogic Servers and Clusters. The attributes define the JDBC environment that includes:

• Connection Pools

• MultiPools

• DataSources

Configuring Connection Pools

Before starting WebLogic Server, you use the Administration Console to configure the connection pool, which includes defining the attributes and connection parameters, cloning pools, and assigning connection pools to a server or domain.

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 back-up pool or the high availability algorithm behavior.

Configuring DataSources

As with Connection Pools and MultiPools, you create the DataSource objects in the Administration Console. DataSource objects can be defined with or without transaction services. For DataSource objects with transaction services, see Managing JTA in the Administration Guide.

Monitoring JDBC Connectivity

The Administration Console provides tables and statistics to enable monitoring the connectivity parameters for each of the sub-components, Connection Pools, MultiPools and DataSources.