What is Connection Pooling?

With servlets, opening a database connection is a major bottleneck because we are creating and tearing down a new connection for every page request and the time taken to create connection will be more. :The Java 2 Enterprise Edition (J2EE) specification provides a distributed services-based architecture for implementing highly scalable, reliable, and available e-business applications. In general, a J2EE application architecture maps to the Model-View-Controller (MVC) framework -- repositories/external system resources support the domain model (Model), JSPs/Servlets manage the presentation (View), and EJBs deal with the business logic (Controller).:Connection Pooling is the process of creating and storing the connection instances into the buffer of pool:connection pool is a java program, wen we call the program it get min connections from database server and holds them with in. those connection are granted to the users.if users want more connections the connection pool gets few more connection and grants them.
Category:JDBC Interview Questions