Interested to Buy Any Domain ? << Click Here >> for more details...
wa is connection pooling? how do u create connection
pooling?wat is use connection pooling?
- 1 Answers
- 6236 Views
- Covansys, I also Faced
- E-Mail Answers
Answer Posted / rikin patel
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. 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 ? | 5 Yes | 3 No |
Post New Answer View All Answers
Is uri the same as url?
What is database deadlock ? How can we avoid them?
Are all the required JDBC drivers to establish connectivity to my database part of the JDK?
What is the major difference between java.util.date and java.sql.date data type?
What does the jdbc driver interface do?
What is the use of getGeneratedKeys() method in Statement?
What are the different types of interfaces in the api component?
What are the flow statements of jdbc?
What are the main steps in java to make JDBC connectivity?
What is the execute method in java?
What are the conditions applies to varchar variable, when using in procedures?
What are the jdbc statements?
Explain the difference between resultset and rowset in jdbc
What is hbm xml?
What is batch processing and how to perform batch processing in jdbc?
