|
Home > Archive > WebSphere Application Server > January 2006 > DataSource maximum number of connections
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DataSource maximum number of connections
|
|
|
| Hello,
Simple question, but I have a doubt... :-)
When a DataSource is defined and looked up from different Application
Servers, each can establish the maximum number of connections defined, or am
I wrong ?
For example:
* DataSource defined at Cell scope
* maximum 10 connections
* 5 Web Modules running in 5 different Application Servers on 5 different
Nodes
* applications use all connections at the same time
-> 5 * 10 = 50 connections will be established with the Database. Is this
correct ?
Also, does it change something if the applications ran on the same Node ? Or
in the same Application Server ?
Thanks.
| |
| Ken Hygh 2006-01-23, 6:14 pm |
| Ben_ wrote:
>Hello,
>
>Simple question, but I have a doubt... :-)
>
>When a DataSource is defined and looked up from different Application
>Servers, each can establish the maximum number of connections defined, or am
>I wrong ?
>
>For example:
>* DataSource defined at Cell scope
>* maximum 10 connections
>* 5 Web Modules running in 5 different Application Servers on 5 different
>Nodes
>* applications use all connections at the same time
>
>-> 5 * 10 = 50 connections will be established with the Database. Is this
>correct ?
>
>Also, does it change something if the applications ran on the same Node ? Or
>in the same Application Server ?
>
>Thanks.
>
>
>
>
The database can see a maximum of
Max connections defined on the datasource
times
Application server instances (Server JVMs) that have any applications
that use that datasource.
Number of nodes is irrelevant, as is number of EARs/WARs.
Ken
|
|
|
|
|