mybatis-spring多数据源配置

2024-09-06 08:20:36

mybatis-spring多数据源配置

1.注意事项：在MapperScannerConfigurer里配置的时候，每个数据源的mapper接口应放到不同的包中，下面的例子中用粗体标明，另外，对于mybatis-config.xml配置文件，如果每个数据源配置不同，也最好有多个

2.mapper.xml配置文件可以放到一个目录里，但是为了区分，最好也分开放

3.配置的例子

<bean id="parentDataSource" class="org.apache.commons.dbcp.BasicDataSource">

<property name="driverClassName" value="com.mysql.jdbc.Driver"/>

<property name="maxActive" value="150"/>

<property name="minIdle" value="5"/>

<property name="maxIdle" value="20"/>

<property name="initialSize" value="30"/>

<property name="logAbandoned" value="true"/>

<property name="removeAbandoned" value="true"/>

<property name="removeAbandonedTimeout" value="10"/>

<property name="maxWait" value="1000"/>

<property name="timeBetweenEvictionRunsMillis" value="10000"/>

<property name="numTestsPerEvictionRun" value="10"/>

<property name="minEvictableIdleTimeMillis" value="10000"/>

<property name="validationQuery" value="SELECT 1"/>

</bean>

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

<property name="dataSource" ref="dataSource"/>

</bean>

<bean id="dataSource" parent="parentDataSource">

<property name="url" value="${mysql.jdbc.url}"/>

<property name="username" value="${mysql.jdbc.username}"/>

<property name="password" value="${mysql.jdbc.password}"/>

</bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

<property name="dataSource" ref="dataSource"/>

<property name="mapperLocations" value="classpath*:mybatis/mappers/*.xml"/>

<property name="configLocation" value="classpath:mybatis/mybatis-config.xml"/>

</bean>

<bean name="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">

<property name="basePackage" value="com.qunar.fuwu.ticket.config.dao"/>

<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />

</bean>

<context:component-scan base-package="com.qunar.fuwu.ticket.config.dao"/>

<bean id="transactionManager1" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

<property name="dataSource" ref="dataSource_1"/>

</bean>

<bean id="dataSource_1" parent="parentDataSource">

<property name="url" value="${mysql.jdbc.datasource1.url}"/>

<property name="username" value="${mysql.jdbc.datasource1.username}"/>

<property name="password" value="${mysql.jdbc.datasource1.password}"/>

</bean>

<bean id="sqlSessionFactory_1" class="org.mybatis.spring.SqlSessionFactoryBean">

<property name="dataSource" ref="dataSource_1"/>

<property name="mapperLocations" value="classpath*:mybatis/mappers/*.xml"/>

<property name="configLocation" value="classpath:mybatis/mybatis-config.xml"/>

</bean>

<bean name="mapperScannerConfigurer_1"

class="org.mybatis.spring.mapper.MapperScannerConfigurer">

<property name="basePackage" value="com.qunar.fuwu.ticket.config.dao2" />

<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory_1" />

</bean>

</beans>

最新文章

热门文章