Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using datasource - connection pooling

 
riicha singh
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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.

Thanks,
Richa
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Richa,
Welcome to JavaRanch!

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.
 
riicha singh
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Jeanne,

I am using microsoft sql server driver 2000.


-
Richa
 
Roger Chung-Wee
Ranch Hand
Posts: 1683
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic