InfoCenter Home >
6: Administer applications >
6.6: Tools and resources quick reference >
6.6.14: Administering database connections (overview)

6.6.14: Administering database connections (overview)

The WebSphere administrator has an important role in establishing and maintaining connection pools through data sources and drivers:

  • Configuring the resources used in connection pooling -- JDBC drivers and data sources

    The administrator needs to configure data sources and JDBC drivers for each brand and version of database from which enterprise applications or individual resources will require connections.

  • Adjusting connection pooling parameters for optimal performance.

    Connection pools provide a way to share the connection overhead among multiple requests, but it is possible to configure too large a connection pool. The administrator needs to determine the optimal value for the pool size and other settings, based on environmental factors such as the operating system in use.

JDBC Drivers and data sources are used by Java components requiring database access, such as servlets.

Procedure for introducing JDBC drivers

To introduce JDBC drivers into the WebSphere Application Server environment:

  1. Create a WebSphere JDBC driver configuration that specifies where to find the driver code on the physical machine.
  2. Create a WebSphere data source configuration.
  3. Perform an administrative "installation" of the JDBC driver into WebSphere.

Use the administrative client of your choice to perform the above steps (see Related information). The Create Data Source task wizard in the Java administrative console is recommended because it leads you through all of the above steps.

Go to previous article: Configuring new User Profile Managers with the Java administrative console Go to next article: Properties of JDBC drivers

 

 
Go to previous article: Configuring new User Profile Managers with the Java administrative console Go to next article: Properties of JDBC drivers