What is the difference between Connection Pool and data source?

Answers were Sorted based on User's Feedback



What is the difference between Connection Pool and data source?..

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

What is the difference between Connection Pool and data source?..

Answer / hitler

The Connection pool means equals instance of connections and
it refereed Data Source object.

Is This Answer Correct ?    10 Yes 2 No

What is the difference between Connection Pool and data source?..

Answer / vijaya kumar

DataSource is an object reference which provides jdbc client to obtain a connection from connection pool.

Connection Pool is collection of ready to use database connections to connect the database.

Is This Answer Correct ?    4 Yes 1 No

What is the difference between Connection Pool and data source?..

Answer / raju

Connection pool is an mechanism of pre-creating group of connections and keeping them in cache memory for use and reuse.
DataSource is an interface in javax.sql ackage.Datasource is nothing but object oriented representation of connection pool or DataSource can be called as connection factory.
Coming to DataSource implementations some third parties have implemented this datasource and also server vendors like Tomcat,Websphere also implemented.

NOTE:mostly we use the server implemented DataSources

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Weblogic Interview Questions

What is the boot?

0 Answers  


What Is Boot.proerties File In Weblogic Server ?

0 Answers  


How can the OUT OF MEMORY be solved?

0 Answers  


What is bea weblogic? : BEA Weblogic

0 Answers  


Which of the recommended practices to be performed in the ejbpassivate() method of a stateful session bean? : BEA Weblogic

0 Answers  






What is meant by gc, prallel gc, full gc and explain it?

0 Answers  


Why does for update in oracle 8 cause an ora-01002 error? : BEA Weblogic

0 Answers  


Explain the functionality of iiop ?

0 Answers  


What are weblogic clusters?

0 Answers  


When configuring a source or target messaging bridge destination, do I need to set the adapter classpath field? : BEA Weblogic

0 Answers  


Explain the diffrernces between 8.x and 9.x?

0 Answers  


What is the difference between development mode and production mode of weblogic server?

0 Answers  


Categories