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:
- Create a WebSphere JDBC driver configuration that specifies where to
find the driver code on the physical machine.
- Create a WebSphere data source configuration.
- 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.
|