Connection Pooling

• When we create a java enterprise application interacting with database is very common.
• Creating and establishing connection with database is an expensive process.
• Establish Network Connections
• Initialize Database sessions
• Authorize back-end database
• So it is always a good process to use connection pool in our application.
• It increases the performance and scalability of application.
• We can reuse existing connections and prepared statements which helps to avoid the cost of establishing connections.
• Example of Libraries for connection pooling are "C3P0" and "dbcp" etc.
• Hibernate c3p0 dependency is used for Connection Pooling in Hibernate?