File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB and other Java EE Technologies and the fly likes Websphere 4.0 connection pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Websphere 4.0 connection pooling" Watch "Websphere 4.0 connection pooling" New topic

Websphere 4.0 connection pooling

Raj Jindal
Ranch Hand

Joined: Jan 17, 2003
Posts: 50
Howz connection pooling implemented in websphere 4.0 ?
If I specify a count of 10 connection in the configuration. wat will happen if 100 users hits my site at the same time.
Nagendra Prasad
Ranch Hand

Joined: Jul 11, 2002
Posts: 219
The relation between users htting the site and the connection pool is something that needs to be handled by the application.
By setting a value of 10, what you are doing is obtaining 10 connections to the database.
How u use these connections is dependant on how you write your code. If you think in terms of client/server where each user has their dedicated connection, then if a 100 users log in, then yes you would have a problem.
If you look at web applications, most of them obtain a connection only when necessary (i.e when a db transaction is abt to be made) and release it shortly thereafter.
So, 100 users might still be able to get their requests properly serviced.
However, if 100 concurrent db requests are made, there could be one of two things happening
- a wait time before a request is processed
- an error situation.

Best Regards,<br />Nagendra Prasad.
I agree. Here's the link:
subject: Websphere 4.0 connection pooling
jQuery in Action, 3rd edition