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 209.85.220.214 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :cc:content-type;
        b=cpxVmHBPJWk9Hz73fXTQiZZGgdMOUGmYAXH1ggQOJZbDTFGd5wSqQlWRKS+LSn7Wsl
         vB0gwOpqf49uRg1/B++tUDJqEffGaKE2JjrJAoJR2y+/SumEYSkWgqhzRwquulnKGZSK
         phH6jNvwKxbdJF1upB5eKpAK5GU6PA2KvHv/o=
MIME-Version: 1.0
In-Reply-To: <4B1FDB65.7000303@apache.org>
References: <2fb267f80912090913uba5aa4eq61a78d520003e39a@mail.gmail.com>
	 <4B1FDB65.7000303@apache.org>
Date: Wed, 9 Dec 2009 17:51:49 +0000
Message-ID: <2fb267f80912090951v5f5e81c7x6461f7e99b5e5bf9@mail.gmail.com>
Subject: Re: 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=001485f772e0538ccb047a4f586a

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

Thanks Mark.

Can you confirm that I can have one data source "shared" across all contexts
with the following configurations:

In CATALINA_BASE/conf/server.xml, I define a GlobalNamingResource as
follows:

<GlobalNamingResources>
...
...
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"/>*

</GlobalNamingResources>

I then reference it in CATALINA_BASE/conf/context.xml as follows:

<Context>
            <ResourceLink name="@tomcat.context.ece.read.ds.resource@"
            global="@tomcat.context.ece.read.ds.resource@"
            type="@tomcat.context.driver.type@"/>
</Context>

Information obtained from your reply and
http://tomcat.apache.org/tomcat-5.5-doc/config/globalresources.html

Kind Regards

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

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

http://www.google.com/profiles/anuragkapur
------------------------------------------------------------------
Sent from Poplar, Greater London, United Kingdom

On Wed, Dec 9, 2009 at 5:16 PM, Mark Thomas <markt@apache.org> wrote:

> Anurag Kapur wrote:
> > 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:
>
> <snip/>
>
> > 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?
>
> One DS is created for each context.
>
> If you want a single DS, create it is a global resource and then
> reference the global resource from CATALINA_BASE/conf/context.xml
>
> Mark
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

--001485f772e0538ccb047a4f586a--