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 Single Server Edition manages database connections for applications installed in the application server runtime. For example, applications might require data access in order to persist sessions.

Note, unlike Advanced Edition Version 4.x, and both Advanced and Standard Edition Version 3.5.x, Advanced Single Server Edition Version 4.x does not keep its administrative data in a database. There is no administrative database to install or administer. (However, the WebSphere samples still require the installation and configuration of a database -- see the samples documentation for details).

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.

Go to previous article: Updating transport configurations with the Web console Go to next article: Properties of JDBC and data source providers

 

 
Go to previous article: Updating transport configurations with the Web console Go to next article: Properties of JDBC and data source providers