File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes IDEs, Version Control and other tools and the fly likes Connection_Pooling in WSAD Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Connection_Pooling in WSAD" Watch "Connection_Pooling in WSAD" New topic

Connection_Pooling in WSAD

Monoj Roy
Ranch Hand

Joined: Oct 10, 2007
Posts: 98
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

Joined: May 26, 2003
Posts: 32819

You can tell from the class name of the driver your datasources it uses whether it is XA. Or connection pooling for that matter.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Monoj Roy
Ranch Hand

Joined: Oct 10, 2007
Posts: 98
Hi ,

Thanks for the response.

The provider I am using is as follows

JDBC Provider :

So If I am not wrong I am using Connection Pooling . Thanks for clearing me the Idea .
I agree. Here's the link:
subject: Connection_Pooling in WSAD
It's not a secret anymore!