connection pooling in websphere

[vikasids sharma]

We need to retrieve datasource at client code to get benifit of pooled connections from an application server for connecting to databse. We retrieve it using JNDI.
Can we get benifit of implicit connection pooling provided by websphere without using JNDI.
thanks
Vikas

[Chris Mathews]

Moving to the IBM/Websphere Forum...

[Scott Duncan]

do not think you can do this.

[Ashoke Bhowmick]

Originally posted by vikasids sharma:
We need to retrieve datasource at client code to get benifit of pooled connections from an application server for connecting to databse. We retrieve it using JNDI.
Can we get benifit of implicit connection pooling provided by websphere without using JNDI.
thanks
Vikas

What do you gain by avoiding JNDI ? Although JNDI lookup is a costly operation , you don't need to do it everytime you access the database. There can be a utility class in your app that caches the DataSource object and you can provide a static method on that class to get connection. There will be only one JNDI call to get the DataSource and later on the DataSource object can be used again and again.
Regards,
Ashoke Bhowmick