30/01/25
----------
Q)How are the limitations of DriverManager overcome?
=>by using DataSource

Q)What is DataSource?
 =>DataSource is a connection factory. I.e. it provides database
 connections to Java application.
 =>Object oriented representation of connection pool is nothing but
 DataSource

Q)What is a connection pool?
=>A group of (collection of) pre-created database   connections kept in cache for use and reuse is   nothing but a connection pool.

Q)What is connection pooling?
=>The mechanism  of creating  the connection    pool  and providing  pooled connections     to application components  is nothing but  connection pooling.

Q)How is connection pool created?
=>Once the application server(Tomcat/Weblogic/Web Sphere/JBoss) administrator
configures the connection pool, Connection pool is created.

Q)How to get a pooled connection in a Java application?
=>Java component that needs a pooled connection should perform the following
things.
   1)Connect to the naming service.

             InitialContext ic=new InitialContext();


   2)    Perform lookup for DataSource object.
                    DataSource ds=(DataSource)ic.lookup("myds");

   3)  Connection connection=ds.getConnection();