What is the difference between Connection Pool and data source?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I identify the document type of an xml document? : BEA Weblogic

685


Which memory space does thread stack get allocated from?

672


How to pass arugments to server through machine?

663


What is meant by jdbc and configuration details?

753


How do I call oracle stored procedures that take no parameters? : BEA Weblogic

693


What is weblogic?

794


List components of jndi?

728


Why would a client application use jta transactions?

664


Do ejbs have to be homogeneously deployed across a cluster?

769


tell me the permenent memory issues?

2452


How can I debug the java code that I have running in weblogic server? : BEA Weblogic

647


Why do we need to remove cache?

727


How can I set deployment order for applications?

759


What is a Thread dump? How will you take in unix/linux and windows ?

792


What are data-sources and what features do they offer?

728