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.

[ Post a follow-up to this message ]

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 a
m
>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 ? O
r
>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

[ Post a follow-up to this message ]