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

What are the enhancements in ejb 2.0 with respect to cmp?

504


What is a domain?

597


How Can Cluster Communication Occur ?

575


When should I use the external_stage option?

602


Do you know what is the meaning of classformaterrors used with the applet?

487






What is non-stage deployment?

625


When deploying a resource adapter (.rar) to weblogic server, are its classes placed in the weblogic classpath? : BEA Weblogic

537


tell me the permenent memory issues?

2292


In what ways can a web logic servers performance be improved upon?

520


How is the security handled in web logic j2ee connector architecture?

541


Differences between an application server and a web-server? What is the conman architecture which is used forhigh availability and load balancing describe in few lines.

497


What is the function of T3 in WebLogic Server ?

733


What are the common domain types?

554


What is cluster in weblogic?

494


What all jvm analysis/profiling tools you are familiar with please write the names?

483