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