<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:task="http://www.springframework.org/schema/task"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:mybatis="http://mybatis.org/schema/mybatis-spring"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd"
default-lazy-init="true">
<description>mybatis配置</description>
<bean name="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<!-- 指定 domain 路径,为Java类型命名一个短的别名,例如:com.mochasoft 的别名是Category -->
<property name="typeAliasesPackage" value="cmcc.unify.backlog.collection"/>
<!-- 指定单个类-->
<!-- 指定mapper.xml路径 -->
<property name="mapperLocations" value="classpath:cmcc/unify/backlog/collection/**/mapper/*.xml"></property>
<!-- 1.配置mybatis属性第一种方式:指定 mybatis的配置文件 -->
<!-- 2.配置mybatis属性第二种方式:直接配置mybatis属性。-->
<property name="configuration">
<bean class="org.apache.ibatis.session.Configuration">
<property name="cacheEnabled" value="${mybatis.cacheEnabled}"/>
<property name="useGeneratedKeys" value="${mybatis.useGeneratedKeys}"/>
<property name="defaultExecutorType" value="${mybatis.defaultExecutorType}"/>
<property name="mapUnderscoreToCamelCase" value="${mybatis.mapUnderscoreToCamelCase}"/>
<property name="lazyLoadingEnabled" value="${mybatis.lazyLoadingEnabled}"/>
<property name="multipleResultSetsEnabled" value="${mybatis.multipleResultSetsEnabled}"/>
<property name="useColumnLabel" value="${mybatis.useColumnLabel}"/>
<property name="defaultStatementTimeout" value="${mybatis.defaultStatementTimeout}"/>
<property name="jdbcTypeForNull" value="NULL"></property>
</bean>
</property>
</bean>
<!-- scan for mappers and let them be autowired,类和xml在同一目录中,名称相同,则自动绑定 -->
<!-- mybatis 事物托管给spring-->
<bean name="transcationManagerMybatis" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<tx:annotation-driven transaction-manager="transcationManagerMybatis"/>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="cmcc.unify.backlog.collection.**.mapper" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
<bean name="dataSource_2" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="url" value="${sgs.db.url}" />
<property name="username" value="${sgs.db.username}" />
<property name="password" value="${sgs.db.password}" />
<!-- 初始化连接大小 -->
<property name="initialSize" value="0" />
<!-- 连接池最大使用连接数量 -->
<property name="maxActive" value="20" />
<!-- 连接池最大空闲 -->
<property name="maxIdle" value="20" />
<!-- 连接池最小空闲 -->
<property name="minIdle" value="0" />
<!-- 获取连接最大等待时间 -->
<property name="maxWait" value="60000" />
</bean>
<bean name="sqlSessionFactory2" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource_2"/>
<!-- 指定 domain 路径,为Java类型命名一个短的别名,例如:com.mochasoft 的别名是Category -->
<property name="typeAliasesPackage" value="cmcc.unify.backlog.transform"/>
<!-- 指定单个类-->
<!-- 指定mapper.xml路径 -->
<property name="mapperLocations" value="classpath:cmcc/unify/backlog/transform/**/mapper/*.xml"></property>
<!-- 1.配置mybatis属性第一种方式:指定 mybatis的配置文件 -->
<!-- 2.配置mybatis属性第二种方式:直接配置mybatis属性。-->
<property name="configuration">
<bean class="org.apache.ibatis.session.Configuration">
<property name="cacheEnabled" value="${mybatis.cacheEnabled}"/>
<property name="useGeneratedKeys" value="${mybatis.useGeneratedKeys}"/>
<property name="defaultExecutorType" value="${mybatis.defaultExecutorType}"/>
<property name="mapUnderscoreToCamelCase" value="${mybatis.mapUnderscoreToCamelCase}"/>
<property name="lazyLoadingEnabled" value="${mybatis.lazyLoadingEnabled}"/>
<property name="multipleResultSetsEnabled" value="${mybatis.multipleResultSetsEnabled}"/>
<property name="useColumnLabel" value="${mybatis.useColumnLabel}"/>
<property name="defaultStatementTimeout" value="${mybatis.defaultStatementTimeout}"/>
<property name="jdbcTypeForNull" value="NULL"></property>
</bean>
</property>
</bean>
<!-- scan for mappers and let them be autowired,类和xml在同一目录中,名称相同,则自动绑定 -->
<!-- mybatis 事物托管给spring-->
<bean name="transcationManagerMybatis2" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource_2"/>
</bean>
<tx:annotation-driven transaction-manager="transcationManagerMybatis2"/>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="cmcc.unify.backlog.transform.**.mapper" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory2"/>
</bean>
</beans>
注意，两个数据源引用包需要分开，不可混用
