I am using websphere application developer for my j2ee application (jsp, servlets). I have to do connection pooling for my application. for this I have configured a datasource object in websphere.
I am using javax.sql.DataSource object to get the connection
Context ctx = new InitialContext(); javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("jdbc/ds1"); Connection con = ds.getConnection(userid, pwd);
I want to know that whether using a javax.sql.DataSource object as above will provide connection pooling. Or do I have to used objects of javax.sql.PooledConnection or javax.sql.ConnectionPoolDataSource classes.
The code itself is the same whether you use connection pooling or not. When you set up the ds1 datasource, it uses a certain class from the driver. That class determines whether connection pooling is used. For example, db2 provides a non-connection pool datasource, a connection pool datasource and an XA (transactional) datasource in the driver zip file.
Each JDBC data source has a pool of JDBC connections that is created when the data source is deployed or at server startup. For this to work, you must first configure a connection pool in WAS and then associate your DataSource with the pool.
The code you have posted will obtain the connection wrapper object from the pool.