Connection Pools

A connection pool is a set of cached database connection objects, created and kept in a pool, which can be multiplexed to provide multiple clients access to a database resource. Figure 7.7 illustrates the concept of a connection pool.

Figure 7.7. Connection pool.

Besides the features explained earlier, note the following important points in favor of connection pools. While programming direct JDBC connections, generally the user ID and password have to be included into the code or have to be picked up from a .properties file. This could turn out to be a sensitive issue in terms of the security of a system. To ensure security of ...

Get Sams Teach Yourself BEA WebLogic Server 7.0™ in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.