스프링 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>