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

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

Answer / 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

Is This Answer Correct ?    5 Yes 3 No

Post New Answer

More JDBC Interview Questions

can we create a own jdbc driver? how can we create?

1 Answers   HCL,

what are the Different types of exceptions in JDBC?

1 Answers  

What are stored procedures? How to call them?

3 Answers  

What are static and dynamic queries?

1 Answers  

Hi my doubt is that preparedStatement is a interface means which has no implemenation.plz go thru the code below String sql = "SELECT * FROM movies WHERE year_made = ?"; prest = con.prepareStatement(sql); prest.setInt(1,2002); ResultSet rs1 = prest.executeQuery(); Now setInt and executeQuery how it works since it is interface it does not have implementation how it works, how executeQuery returns result from database as executequery method has no implementation even in Statement interface.

4 Answers   Hexaware, Cybermate,

Explain the sequence of steps to connect to the database?

3 Answers   Wipro,

What is the exception thrown by JDBC ?

7 Answers  

PreparedStatement is a pre compiled statement but where it's pre compiled ?

4 Answers  

What is execute(), executeUpdate() and executeQuery() methods?

10 Answers  

What are the common JDBC problems that you got and how do you solved them?

0 Answers   Wipro,

How many types of JDBC drivers are there and what are they?

2 Answers   TCS,

How is jndi useful for Database connection?

1 Answers