wa is connection pooling? how do u create connection
pooling?wat is use connection pooling?

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


Please Help Members By Posting Answers For Below Questions

What are the different types of locking in JDBC?

547


What is jdbc vs odbc?

489


Give an example for getXXX method?

537


What is odbc and jdbc in dbms?

503


What is ODBC and JDBC? How do you connect the Database?

513






Why do I get UnsatisfiedLinkError when I try to use my JDBC driver?

548


Is jdbc connection secure?

484


What is “dirty read” in JDBC? Which isolation level prevents dirty read?

568


What is SQL Warning? How to retrieve SQL warnings in the JDBC program?

529


Is possible to open a connection to a database with exclusive mode with JDBC?

522


What is preparedstatement in jdbc?

494


How do I stop nullpointerexception?

492


Why are we using blob datatypes in jdbc?

535


Why do we use jdbc in java?

520


What is jdbc drivers in java?

478