<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean id="dataSource_Abstract" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" singleton="true" abstract="true"> <property name="driverClassName"> <value>net.sourceforge.jtds.jdbc.Driver</value> </property> <property name="username"> <value>sa</value> </property> <property name="password"> <value>password</value> </property> <property name="maxActive"> <value>20</value> </property> <property name="maxIdle"> <value>20</value> </property> <property name="minIdle"> <value>15</value> </property> <property name="maxWait"> <value>10000</value> </property> <property name="validationQuery"> <value>SELECT 1</value> </property> <property name="testOnBorrow"> <value>true</value> </property> <property name="removeAbandoned"> <value>true</value> </property> <property name="removeAbandonedTimeout"> <value>60</value> </property> <property name="logAbandoned"> <value>false</value> </property> </bean> <bean id="dataSource_Database_ABC" parent="dataSource_Abstract"> <property name="url"> <value>jdbc:jtds:sqlserver://127.0.0.1:1433/Database_ABC</value> </property> </bean> <bean id="dataSource_Database_XYZ" parent="dataSource_Abstract"> <property name="url"> <value>jdbc:jtds:sqlserver://127.0.0.1:1433/Database_XYZ</value> </property> </bean> </beans>