Difference between getting Connection directly from the pool or from a DataSource

[Fred Close]

What's the difference between getting a connection directly from a Connection Pool

   Driver myDriver = (Driver) Class.forName(driver).newInstance();
          conn = myDriver.connect(connectionPool, null);  

and getting a connection from a Datasource

         Context initialContext = new InitialContext();
          DataSource ds = (DataSource)initialContext.lookup(DSName);
          conn = ds.getConnection();

at the end the result will be the same : a connection from the connection pool will be returned ... so what's the difference between the two techniques ?

[Chris Mathews]

The difference as getting from the Connection Pool directly means coupling your application to WebLogic. Looking up a datasource in JNDI is as vendor independent as you can get.
[ December 03, 2002: Message edited by: Chris Mathews ]

[Rahul Mahindrakar]

The first case
1) Connection is created for you every time
2) Is a huge performance bottleneck since it uses reflection API