DBCP is extremely useful and applicable where user wants hassle free and quicker response using the available connections as making new connection is very time consuming process. On the other hand, retrieving request with open connections is hassle free and easy process and give same result in quicker time within a giant database application.
The database enabled applications needs the database connection for processing the request send by the clients and at a single time, myriad numbers of request are send for retrieving the data, at that time DBCP works.
The utility of DBCP enhances where quick database accessing is required for every clients at a given time frame on a giant network like internet or any big enterprise network, where millions of requests are send within a single point of time.
In this process, the programmers share a pool of open connections available among them for retrieving the quick data. The pool manger of DBCP logs the request into DBMS, process internally and returns to relating clients.
There are several Database Connection Pools already available, both within Apache products and elsewhere. But now, DBCP is coming in two different variants ? DBCP 1.4 and DBCP 1.3.
The DBCP 1.4 supports JDBC 4, compiles and runs under JDK 1.6 while DBCP 1.3 supports JDBC 3 and compiles and runs under JDK 1.4-1.5 only. You can choose one appropriate version according to your requirements.Connecting to MySQL
Recommend the tutorial