스프링 datasource 2개 이상, datasource 멀티

 sqlSessionTemplate bean 부분에 primary="true"를 설정한다.

Colored By Color Scripter™

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

<bean id="dataSourceOne" destroy-method="close" class="org.apache.commons.dbcp2.BasicDataSource">         <property name="driverClassName" value="com.mysql.jdbc.Driver" />         <property name="url" value="jdbc:mysql://1.1.1.1:3306/test" />         <property name="username" value="1111" />         <property name="password" value="1111" />         <property name="initialSize" value="1" />      </bean> <bean id="sqlSession" class="org.mybatis.spring.SqlSessionFactoryBean">         <property name="dataSource" ref="dataSource" />         <property name="mapperLocations">             <list>                 <value>classpath*:aaa/a1/**/*.xml</value>             </list>         </property>     </bean>    <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate" primary="true">         <constructor-arg index="0" ref="sqlSession"/>     </bean>        <bean id="dataSource2" destroy-method="close" class="org.apache.commons.dbcp2.BasicDataSource">         <property name="driverClassName" value="com.mysql.jdbc.Driver" />         <property name="url" value="jdbc:mysql://2.2.2.2:3306/test" />         <property name="username" value="2222" />         <property name="password" value="2222" />         <property name="initialSize" value="1" />      </bean> <bean id="sqlSession" class="org.mybatis.spring.SqlSessionFactoryBean">         <property name="dataSource" ref="dataSource2" />         <property name="mapperLocations">             <list>                 <value>classpath*:bbb/b1/**/*.xml</value>             </list>         </property>     </bean>    <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">         <constructor-arg index="0" ref="sqlSession"/>     </bean>