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 (nike.apache.org: domain of cjderham@gmail.com designates
 209.85.212.45 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:reply-to:in-reply-to:references:from:date
         :x-google-sender-auth:message-id:subject:to:content-type;
        b=MpOtCup9TYx+XFyHB9+dWXtxAHav9O/5aXcLgXD0s1A+ombxozPjW46g7pbpF8rbzk
         bZxfSFOOqPISEMnx99i5VA0GY+LjHmPINIHU7n5pegh3n34cAxPB39MA7HulzeiLxM+Z
         //5HrdBorx2GMjIhdkzVSYer7GYa6pFoWJF38=
MIME-Version: 1.0
Sender: cjderham@gmail.com
Reply-To: chris@derham.me.uk
In-Reply-To: <4D526331.7010702@axivion.com>
References: <4D525B8B.5080900@axivion.com>
 <AANLkTinmGf2mu+5P2hK0jJ8Rd4tfzoyOs+fJsMeWqjkD@mail.gmail.com>
 <4D526331.7010702@axivion.com>
From: chris derham <chris@derham.me.uk>
Date: Wed, 9 Feb 2011 08:03:15 -0200
Message-ID: <AANLkTikNucHDkqQmKnZ2Mm+DfZHY6fY4ME_Qt2yFQCjo@mail.gmail.com>
Subject: Re: Context.xml for multiple datasources
To: Tomcat Users List <users@tomcat.apache.org>
Content-Type: multipart/alternative; boundary=90e6ba53a5460c20e4049bd6941c

--90e6ba53a5460c20e4049bd6941c
Content-Type: text/plain; charset=ISO-8859-1

> And the question is:
> How to build the context to move the existing Spring configuration to the
> Tomcat context to get all datasources with JNDI.
> The problem is, that it must be possible to set a variable amount of
> databases. I can't set the number of databases to a fixed amount.
>
Building the Resources for the beans named parentDataSource, firstDataSource
> and secondDataSource is like configuring a single database.
> But How can I create a JNDI lookable resource like the bean named
> dataSource containing a map of all available database resources?
>

>From your original post, in which you stated "This is my working Spring
datasource.xml:"

<bean id="dataSource" class="com.ax.dashboard.
datasource.AxRoutingDataSource">
<property name="targetDataSources">
<map key-type="java.lang.String">
<entry key="first" value-ref="firstDatasource" />
<entry key="second" value-ref="secondDataSource" />
</map>
</property>
<property name="defaultTargetDataSource" ref="firstDatasource" />
</bean>

In spring you are building a map of data sources that are also defined in
spring. Why not build a map of data sources that are defined in context.xml
and spring looks them up? You say that you need variable amounts of
databases, but the code you posted and said "this worked" doesn't support
this - to add a new datasource you would have to update spring config. If
you really need variable databases, then some custom code to load a custom
configuration of such data sources might be the way to go. Then just use a
resource element in context to get tomcat to load that for the instance.

Chris

--90e6ba53a5460c20e4049bd6941c--