Interested to Buy Any Domain ? << Click Here >> for more details...
which scenarios we go for jdbc,and which scenario we go for
connection polling and wat r advantages and disadvantages
using connection pooling.
- 2 Answers
- 6494 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / mukundan
First part of the question seems irrelevant as JDBC has to
be used to access RDB irrespective of whether Connection
pooling is used or not.
Advantage of creating and using connection pooling is to
share the number of connections to the database in an
organized and distributed ways when the same RDB is used by
multiple applications.
Using connection pooling is advantageous
(1) the application doesn't overshoot with the number of
connections available/allotted for the application
(2) creating connection with a RDB is a costly operation
where as this is done one time and a pool of connection is
created during the startup of the application
(3) Connections from the pool are readily available for use
and they are reused which is much faster as per (2) above
Disadvantages of Connection pooling:
(1) When multiple application uses a RDB, each application
grabs its share (the allotted number of connections) during
start-up irrespective of its usage of the grabbed
connections. For example, if one application grabs 100
connections up front and its peak usage is only 40 or 50
then they are strictly not available to any other
application who's peak usage may be more than their allocation.
(2) If connections are not released appropriately by the
applications then the performance of the systems could go
haywire.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is drivermanager in java?
Why do we use jdbc?
What are the main steps in java to make JDBC connectivity?
What are the advantages of using jdbc datasource?
What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?
What is the advantage of namedparameterjdbctemplate?
What do you mean by metadata and why we are using it?
How does jdbc connect to database?
Briefly tell about the jdbc architecture.
How can we set null value in jdbc preparedstatement?
How a database driver can be loaded with jdbc 4.0 / java 6?
How do I know which jdbc driver to use?
If you are truncated using JDBC, how can you that how much data is truncated?
Give a way to check that all result sets have bin accessed and update counts are generated by execute method.
What is an SQL Locator?
