Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection_Pooling in WSAD

 
Monoj Roy
Ranch Hand
Posts: 98
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
From roseindia site I got the following lines
***************************************************************************
In short we can say that the DataSource interface is implemented to provide three kinds of connections:

1). Basic DataSource class
This class is provided by the driver vendor.It is used for portability and easy maintence.

2). To provide connection pooling.
It is provided by the application server vendor or driver vendor. It works with ConnectionPoolDataSource class provided by a driver vendor. Its advantage is portability, easy maintenence and increased performance.

3). To provide distributed transactions
This class works with an XADataSource class, which is provided by the driver vendor. Its advantages are easy maintenence, portability and ability to participate in distributed transactions.
***************************************************************************

I use WSAD 5.1.2 and want to know when I configure WebSprere Application Server for Datasource to connect to a specific Datasource which type of connection it is ?

If I want to support connection Pooling or XADataSource how should I configure my application server ?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34422
347
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Monoj,
You can tell from the class name of the driver your datasources it uses whether it is XA. Or connection pooling for that matter.
 
Monoj Roy
Ranch Hand
Posts: 98
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,

Thanks for the response.

The provider I am using is as follows

JDBC Provider : COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource

So If I am not wrong I am using Connection Pooling . Thanks for clearing me the Idea .
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic