This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Connection_Pooling in WSAD" Watch "Connection_Pooling in WSAD" New topic
Author

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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30057
    
149

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, 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 : COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource

So If I am not wrong I am using Connection Pooling . Thanks for clearing me the Idea .
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connection_Pooling in WSAD
 
Similar Threads
Connection Pooling (Urgent)
SQLServer with J2EE 1.3.1
JDBC: Concept of DataSource
Connection Pooling
need help on porting a web application using jta to tomcat