Database Connection Pooling With c3p0

Database connection creation consumes more resources. I have described it in a programming tutorial as well.
Database connection pooling is an option to address this case. We can integrate a connection pooler to our program. c3p0 is a such database connection pooler helps us to create connection pools.

How connection pool works

At the start of the server we release predefined  amount of connections. Once the user want to perform a database related task, we give a connection and release it back to the pool once the user finished the task.
Not only connections, c3p0 can manage statements also.
Also we can make a lot configurations to c3p0 using several configuration options.
I have added a slide show that will describe important parts of c3p0. It will be helpful you to start working with c3p0.

Cilck to get more details about c3p0 and documentation.