Hi all

 

I'm using Tomcat 5.5, and am setting up Connection pools for the
database, using the context.xml file from the META-INF directory. 

We do / will have a multi region series of dev environments  (local,
dev, UAT, PAT, Live etc) as the code gets developed.

Each Resource will point to a different database, and need different
connection settings, e.g

 

<?xml version="1.0" encoding="UTF-8"?>

 <Context crossContext="true" debug="5" path="/ipsl_app"
reloadable="true">

    <Resource

          name="jdbc/connectionPool"

          auth="Container"

          type="javax.sql.DataSource"

          driverClassName="net.sourceforge.jtds.jdbc.Driver"

          factory="org.apache.commons.dbcp.BasicDataSourceFactory" 

          user="sa"

          password="sandstone"

          maxIdle="2"

          maxWait="5000"

 
url="jdbc:jtds:sqlserver://testheat.company.com:1433/test;user=sa;passwo
rd=test"

          maxActive="4"

          removeAbandoned="true" removeAbandonedTimeout="60"
logAbandoned="true"/> 

   </Context>

 

 

My question is how do I put multiple Resource elements within the
Context element, and ensure the correct Resource is read for the correct
environment ? 

The only real idea I have so far on how to do this is to use a different
'name' attribute values for each Resource, and determine which 'name' to
select based on the value in a properties file that would say which
environment (dev, Live) was in use.  

 

But I can't be the first one to run into this problem, and Google wasn't
any help. Can anyone give me any hints on how they've done it, or if
there's a best practice ? The Tomcat documentation wasn't any real help,
and I don't want to have to edit the file before deployment etc. If I'm
on the wrong track completely , let me know.

 

Thanks very much

 

Scott

 



This message has been scanned for viruses by BlackSpider MailControl - 
www.blackspider.com

Reply via email to