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 ...