Answer Posted / bhudeep
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.
Creating a connection pool is an ideal approach for
a complicated servlet. With a connection pool, we can
duplicate only the resources we need to duplicate rather
than the entire servlet. A connection pool can also
intelligently manage the size of the pool and make sure each
connection remains valid. A number connection pool packages
are currently available. Some like DbConnectionBroker are
freely available from
Java Exchange Works by creating an object that dispenses
connections and connection Ids on request.
The Connection Pool class maintains a Hastable,
using Connection objects as keys and Boolean values as
stored values. The Boolean value indicates whether a
connection is in use or not. A program calls getConnection
( ) method of the ConnectionPool for getting Connection
object it can use; it calls returnConnection ( ) to give the
connection back to the pool.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which interface is responsible for transaction management in jdbc?
What is ODBC and JDBC? How do you connect the Database?
What is JDBC Connection? Explain steps to get Database connection in a simple java program.
What is jdbc thin client in oracle?
What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?
What is jdbc and its types?
Is jdbc a framework?
What are the higher level apis under development on top of jdbc currently?
Why do you use a data source object for a connection?
How do I find whether a parameter exists in the request object?
Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?
Explain about column name and getter method?
What are the advantages of using preparedstatement in java?
What are the types of jdbc drivers that exist?
Why we use jdbc instead of odbc?