스프링 2.0 - 다중 데이터소스 사용하기
스프링에서 DataSource 를 여러개 사용하고 싶다면 각 각의 DataSource 를 등록하여 사용합니다. 스프링 빈 설정 파일에 다음과 같이 작성합니다.
<bean id=oneDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value=""/>
<property name="url" value="localhost:"/>
<property name="username" value=""/>
<property name="password" value=""/>
<property name="maxActive" value=""/>
<property name="maxIdle" value=""/>
<property name="maxWait" value=""/>
<property name="poolPreparedStatements" value=""/>
<property name="maxOpenPreparedStatements" value=""/>
<property name="removeAbandoned" value=""/>
<property name="removeAbandonedTimeout" value=""/>
</bean>
<bean id="twoDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value=""/>
<property name="url" value="localhost:"/>
<property name="username" value=""/>
<property name="password" value=""/>
<property name="maxActive" value=""/>
<property name="maxIdle" value=""/>
<property name="maxWait" value=""/>
<property name="poolPreparedStatements" value=""/>
<property name="maxOpenPreparedStatements" value=""/>
<property name="removeAbandoned" value=""/>
<property name="removeAbandonedTimeout" value=""/>
</bean>