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.

Go to previous article: Removing transport configurations with the Java administrative console Go to next article: Properties of JDBC and data source providers

 

 
Go to previous article: Removing transport configurations with the Java administrative console Go to next article: Properties of JDBC and data source providers