spring+mybatis 多数据源整合

直接看spring的配置吧

<!-- 数据源配置 -->  
<bean id="ds1" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">  
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />  
    <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:orcl" />  
    <property name="username" value="test" />  
    <property name="password" value="test" />  
    <property name="defaultAutoCommit" value="false"></property>  
</bean>  
  
<bean id="ds2" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">  
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />  
    <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:orcl" />  
    <property name="username" value="test" />  
    <property name="password" value="test" />  
    <property name="defaultAutoCommit" value="false"></property>  
</bean>  
  
 <bean id="dataSource" class="app.platform.mybatis.DynamicDataSource">  
    <property name="targetDataSources">  
        <map key-type="java.lang.String">  
            <entry value-ref="ds1" key="ds1"></entry>  
            <entry value-ref="ds2" key="ds2"></entry>  
        </map>  
    </property>  
    <property name="defaultTargetDataSource" ref="ds1"></property>      <!-- 默认使用ds1的数据源 -->
</bean>  


<!-- mybatis配置 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="classpath:/mybatis/mybatis-config.xml" />
<property name="mapperLocations" value="classpath*:app/mapper/**/*.xml"/>
</bean>

<!-- 事务管理器配置,单数据源事务 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>

<!-- 事务拦截的类及方法 -->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="get*" read-only="true" />
<tx:method name="find*" read-only="true" />
<tx:method name="query*" read-only="true" />
<tx:method name="is*" read-only="true" />
<tx:method name="do*" propagation="REQUIRES