Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain jdbc savepoint?
Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?
What is correlated subquery?
How can you know about drivers and database information ?
What is jdbc architecture in java?
What is the use of JDBC DriverManager class?
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
Why resultset is used in java?
What is SQL Warning? How to retrieve SQL warnings in the JDBC program?
What driver should I use for scalable Oracle JDBC applications?
What are the classes and methods used for sending sql statements to database?
Explain the difference between inner and outer join ?
What is the function of drivermanager class?
Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.
Name the new features added in jdbc 4.0.
