Connection_Pooling in WSAD

[Monoj Roy]

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]

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]

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 .