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 administrator of Advanced Edition (non-Single Server Edition) establishes
database connections for supporting data access by:
- Applications installed in the server runtime, possibly including the WebSphere Samples
- The WebSphere administrative server for obtaining its administrative data
For information about the latter topic, see the article about administering
the administrative server and database.
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 providers and data sources
The administrator needs to configure data sources and JDBC providers 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 Providers and data sources are used by Java components requiring
database access, such as
servlets and enterprise beans. All entity beans require a datasource,
either defined as a property of the enterprise bean, or as a property
of the enterprise bean container.
|