Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: domain of anuragkapur@gmail.com
 designates 72.14.220.158 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:cc:content-type;
        b=HXMfM3xHg+zZ+jq0dM8aCNcX85uWAAmkQ5WO4whzYP8J3TTr2+Fs5pbF++rSYVybzQ
         JbTpk4mMgG45JXppw1UbUmiq89N8mGhTwSLIwtNe7tTQB/ZzeZyvSBcMQynseLcxPJNP
         yTbmq6FSamydEGmCTv8vzgAjuoPJTYLlObsD0=
MIME-Version: 1.0
Date: Wed, 9 Dec 2009 17:13:35 +0000
Message-ID: <2fb267f80912090913uba5aa4eq61a78d520003e39a@mail.gmail.com>
Subject: Data Source Resource Declaration in Tomcat Context
From: Anurag Kapur <anuragkapur@gmail.com>
To: Tomcat Users List <users@tomcat.apache.org>
Cc: "Kapur, Anurag" <anurag.kapur@newsint.co.uk>
Content-Type: multipart/alternative; boundary=001485f5ebb690a5b9047a4ecf52

--001485f5ebb690a5b9047a4ecf52
Content-Type: text/plain; charset=ISO-8859-1

Tomcat version: 5.5.27
Java version: 1.5.0_14-b03

I have a datasource configured in global context (via present in
[tomcat_home]/conf/context.xml) as follows:

<Context>

Resource name=*"@tomcat.context.ece.read.ds.resource@"* auth=*"Container"
type="@tomcat.context.driver.type@" driverClassName=
"@tomcat.context.driver.class@" url="@tomcat.context.db.url@"
connectionProperties=
"{ValidateConnection=@tomcat.context.validate.connection@
,ConnectionWaitTimeout=@tomcat.context.connection.wait.timeout@}" username=
"@tomcat.context.db.user@" password="@tomcat.context.db.password@"
validationQuery="@tomcat.context.validation.query@" initialSize=
"@tomcat.context.initial.size@" minIdle="@tomcat.context.min.idle@"
maxActive="@tomcat.context.max.active@" maxIdle="@tomcat.context.max.idle@"
  maxWait="@tomcat.context.max.wait@" removeAbandonedTimeout="60"
removeAbandoned="true" logAbandoned="true"/>*
</Context>

I know a DS defined as above is visible across all the contexts defined in
the container. What I want to know is whether the data source is created for
"each" context or is it "shared" across all the available contexts?

I need to know this because if it is duplicated and not shared and the data
source establishes say 5 connections with the DB, it would mean that the
total connections to the DB would be 5 * number of contexts defined in the
container. Thus to estimate the number of DB connections this information is
needed.

Any help appreciated.

Regards

------------------------------------------------------------------
Anurag Kapur
Associate - Technology,
Sapient Corporation.

http://www.linkedin.com/in/anuragkapur

http://www.google.com/profiles/anuragkapur
------------------------------------------------------------------

--001485f5ebb690a5b9047a4ecf52--