jdbc-context

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="
       http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd">

    <bean abstract="true" id="commonPropertyPlaceholder" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <list>
                <value>classpath:prop/common.properties</value>
            </list>
        </property>
    </bean>

    <!--<context:property-placeholder location="classpath:prop/*.properties" order="1" />-->

    <bean id="baseDataSource" abstract="true"
          class="org.apache.tomcat.jdbc.pool.DataSource" destroy-method="close">
        <property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver" />
        <property name="username" value="${dbUser}" />
        <property name="password" value="${dbPassword}" />
        <property name="initialSize" value="5" />
        <property name="maxActive" value="10" />
        <property name="testOnBorrow" value="true"/>
        <property name="validationQuery" value="select 1"/>
    </bean>

    <bean id="dataSourcePortal" parent="baseDataSource">
        <property name="url" value="jdbc:jtds:sqlserver://${dbServer}/${dbName}" />
    </bean>

    <bean id="dataSourceSys" parent="baseDataSource">
        <property name="url" value="jdbc:jtds:sqlserver://${dbServer}/${dbNameSys}" />
    </bean>

    <beans profile="dev" >
        <bean parent="commonPropertyPlaceholder" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="locations">
                <list merge="true">
                    <value>classpath:prop/dev.properties</value>
                </list>
            </property>
        </bean>
    </beans>

    <beans profile="test">
        <bean parent="commonPropertyPlaceholder" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="locations">
                <list merge="true">
                    <value>classpath:prop/test.properties</value>
                </list>
            </property>
        </bean>
    </beans>

    <beans profile="prod">
        <bean parent="commonPropertyPlaceholder" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="locations">
                <list merge="true">
                    <value>classpath:prop/prod.properties</value>
                </list>
            </property>
        </bean>
    </beans>
</beans>