Return-Path: 
 <users-return-221761-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: (qmail 87815 invoked from network); 9 Feb 2011 14:23:06 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 9 Feb 2011 14:23:06 -0000
Received: (qmail 8546 invoked by uid 500); 9 Feb 2011 14:23:02 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 8425 invoked by uid 500); 9 Feb 2011 14:22:58 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 8416 invoked by uid 99); 9 Feb 2011 14:22:56 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Feb 2011 14:22:56 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=5.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [213.131.255.80] (HELO ks101.cryonhost.eu) (213.131.255.80)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Feb 2011 14:22:48 +0000
Received: from [192.168.1.194] (axivion1.tz.uni-stuttgart.de [129.69.226.21])
	(Authenticated sender: web39p11)
	by ks101.cryonhost.eu (Postfix) with ESMTPSA id 91A216E0F5B
	for <users@tomcat.apache.org>; Wed,  9 Feb 2011 15:21:04 +0100 (CET)
Message-ID: <4D52A307.4040403@axivion.com>
Date: Wed, 09 Feb 2011 15:21:59 +0100
From: Stephan Beutel <beutel@axivion.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; de;
 rv:1.9.2.9) Gecko/20100825 Thunderbird/3.1.3
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: Context.xml for multiple datasources
References: <4D525B8B.5080900@axivion.com>
 <AANLkTinmGf2mu+5P2hK0jJ8Rd4tfzoyOs+fJsMeWqjkD@mail.gmail.com>
 <4D526331.7010702@axivion.com>
 <AANLkTikNucHDkqQmKnZ2Mm+DfZHY6fY4ME_Qt2yFQCjo@mail.gmail.com>
 <4D526886.8090806@axivion.com>
 <AANLkTi=PpJpP=c1beotvKdBW8xXNd8GmNwRD7N0ebrK8@mail.gmail.com>
 <4D527F40.2000009@axivion.com>
 <99C8B2929B39C24493377AC7A121E21F9A47DCCAEC@USEA-EXCH8.na.uis.unisys.com>
In-Reply-To: 
 <99C8B2929B39C24493377AC7A121E21F9A47DCCAEC@USEA-EXCH8.na.uis.unisys.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

  Am 09.02.2011 15:02, schrieb Caldarale, Charles R:
>> From: Stephan Beutel [mailto:beutel@axivion.com]
>> Subject: Re: Context.xml for multiple datasources
>> But I thought it could be defined by a map in
>> context.xml like in Spring.
> Even if you did, that wouldn't solve your problem.  You would still have to stop and restart the webapp every time an additional datasource was added to the<Context>  element.
>
> You could provide a<Parameter>  element nested inside the<Context>  that specifies the names of the<Resource>  entries, but there's no automatically created list of<Resource>  elements.
>
>   - Chuck
>
>
> THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
Restarting the webapp is no problem. Rebuilding the war file is a problem.

At the moment I solved it in this was:

<Resource name="jdbc/first" auth="Container" type="javax.sql.DataSource"
                maxActive="100" maxIdle="30" maxWait="10000"
                username="sa" password="" driverClassName="org.sqlite.JDBC"
                url="jdbc:sqlite:C:\firstDatabase.db"/>

<Resource name="jdbc/second" auth="Container" type="javax.sql.DataSource"
                maxActive="100" maxIdle="30" maxWait="10000"
                username="sa" password="" driverClassName="org.sqlite.JDBC"
                url="jdbc:sqlite:C:\secondDatabase.db"/>

<Resource name="jdbc/third" auth="Container" type="javax.sql.DataSource"
                maxActive="100" maxIdle="30" maxWait="10000"
                username="sa" password="" driverClassName="org.sqlite.JDBC"
                url="jdbc:sqlite:C:\thirdDatabase.db"/>

<Environment name="dataSourceNames" value="first, second, third" 
type="java.lang.String"
                 override="false"/>

<Environment name="dataSourceList" value="jdbc/first, jdbc/second, 
jdbc/third" type="java.lang.String"
                 override="false"/>


Spring looks for the two environment vars (dataSourceNames, 
dataSourceList) and inject them into my RoutingDataSource class:

<jee:jndi-lookup id="dataSources" jndi-name="dataSourceList" />
<jee:jndi-lookup id="dataSourceNames" jndi-name="dataSourceNames" />

<bean id="dataSource" 
class="com.ax.dashboard.datasource.AxRoutingDataSource">

<property name="dataSources" ref="dataSources"/>
<property name="dataSourceNames" ref="dataSourceNames" />
</bean>

And in my java class I do the lookup with JNDI:

private void createDataSourceMap() {
         if (this.dataSourceList != null && this.dataSourceNames != null 
&& this.dataSourceList.size() > 0
&& this.dataSourceNames.size() > 0 && dataSourceList.size() == 
this.dataSourceNames.size()) {
             this.dataSources = new HashMap<Object, Object>();
             for (int i = 0; i < dataSourceList.size(); i++) {
                 Context initCtx;
                 Object dataSource = null;
                 try {
                     initCtx = new InitialContext();
                     Context envCtx = (Context) 
initCtx.lookup("java:comp/env");
                     dataSource = envCtx.lookup(dataSourceList.get(i));
                     if(i==0){
                         setDefaultTargetDataSource(dataSource);
                     }

                 } catch (NamingException e) {
                     e.printStackTrace();
                 }
                 dataSources.put(dataSourceNames.get(i), dataSource);
             }
             setTargetDataSources(dataSources);
         }
     }

If someone has a better solution, please let me know.

Regards
Stephan

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org