Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Connection Pool and data source?
- 4 Answers
- 28605 Views
- HCL, HP, Polaris, I also Faced
- E-Mail Answers
Answer Posted / jaydeb chakraborty
Applications access a data source using a connection and
access Databases via DataSource objects.
A DataSource has a set of properties that identify and
describe the real world data source that it represents.
These properties include information such as the location
of the database server, the name of the database, the
network protocol to use to communicate with the server, and
so on.
DataSource object can be thought of as a factory for
connections to the particular data source that the
DataSource instance represents. In a basic DataSource
implementation, a call to the getConnection method returns
a connection object that is a physical connection to the
data source.
DataSource objects that implement connection pooling also
produce a connection to the particular data source that the
DataSource class represents. The connection object that the
getConnection method returns is a handle to a
PooledConnection object rather than being a physical
connection. An application uses the connection object in
the same way that it uses a connection. Connection pooling
has no effect on application code except that a pooled
connection, like all connections, should always be
explicitly closed. When an application closes a connection
that is pooled, the connection is returned to a pool of
reusable connections. The next time getConnection is
called, a handle to one of these pooled connections will be
returned if one is available. Because connection pooling
avoids creating a new physical connection every time one is
requested, it can help applications run significantly
faster.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
How do I use multibyte character sets with weblogic jdriver for informix? : BEA Weblogic
How can the nm be made to work with web logic? Explain?
How do I increase weblogic server memory? : BEA Weblogic
The home of a product cmp entity bean has a finder method, which returns an enumeration of all the products whose price falls below a certain value, which is passed as the method argument. If there are no products in the database to match the above criteria what will be the result of a call to this finder method? : BEA Weblogic
Can you briefly describe local interfaces?
How is security handled in the weblogic j2ee connector architecture? : BEA Weblogic
Does weblogic jms support clustering? : BEA Weblogic
What are managed servers?
How do I publish an xml message? : BEA Weblogic
What can be the reasons for server hang?
Do you know what is the local interface used by web logic server?
How will a single machine run multiple web logic server instances?
How should you type cast a remote object? Why?
A stateful session bean implementing the sessionsynchronization interface is deployed on the weblogic server. Which of the callback methods may be invoked on the bean? : BEA Weblogic
What signal tells the jvm to give a thread dump?
