How to have different context config files for different environments in spring MVC

Question

On my local machine I'm developing using a certain db (sql server), however, when I deploy to the development environment we are running mysql. So everytime before deploying I have to change certain properties in the config file. Properties pertaining to the datasource:

<bean id="dataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver" />
    <property name="url" value="jdbc:mysql://127.0.0.1:3306/mydb" />
    <property name="username" value="myuname" />
    <property name="password" value="mypwd"/>   
</bean>

Is there a way in spring mvc to have different config files for different environments? If so, how would I go about triggering the correct xml for the right environment.

score 1 · Accepted Answer · answered Oct 18 '12 at 15:40

spring mvc to have different config files for different environments?

we store database connection settings in a properties file in tomcat, each tomcat instalaltion then has its own specific db connection. Eg, a local dev box connects to the local DB server, the UAT server connects to UAT ... and so on.

then in app context we have :

<context:property-placeholder location="file:${catalina.home}/conf/database_UAT.properties"
                                  ignore-unresolvable="true"/>

So where app gets deployed determines its DB connection.

score 0 · Answer 2 · answered Oct 18 '12 at 15:37

i think having different config files for just this requirement is not an good idea. you should externalize db configuration in properties file with two different set, one for dev and second for production. and then use spring EL in configuration file to decide which one to use.

Refer to spring EL documentation for more detail

How to have different context config files for different environments in spring MVC

2 Answers2