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 is statement and preparedstatement in java?
Explain the main method?
Is jdbc and orm?
How to move the cursor in scrollable resultset ?
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
What is the full form of jdbc and what is its purpose?
What isolation level is used by the DBMS when inserting, updating and selecting rows from a database?
What do you understand by jdbc datasource?
How can I determine where a given table is referenced via foreign keys?
what happen if we set JDBC string to NULL?
What causes the "No suitable driver" error?
What packages are used by jdbc?
How can I write to the log used by DriverManager and JDBC drivers?
What are the steps to connect to a database in java?
Can I use JDBC to execute non-standard features that my DBMS provides?
