Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / simdhuri
Ans: 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 of 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
ConnectionPool 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 ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are clob and blob data types in jdbc?
How many types of JDBC Drivers are present and what are they?
Is jpa faster than jdbc?
How to set the attribute concurrency in resultset?
Name different methods for getting streams.
What are the differences between stored procedure and functions?
Explain the difference between resultset and rowset in jdbc
any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.
What is connection pooling and why it is used?
What is JDBC Savepoint? How to use it?
Explain in detail about JDBC and its general features?
What is JDBC Connection? Explain steps to get Database connection in a simple java program.
What is the major difference between java.util.date and java.sql.date data type?
Explain the importance of drivermanager.
What is an encrypted internet connection?
