不生效有几种情况,父容器加载了有事务性的service,但在springmvc的配置文件中再次扫描导致失去事务性,这种 网上比较多,大家搜一下就行。 我主要介绍一种比较不容易让人注意的方式就是都数据源情况下加载的必须是统一数据源才行 如下配置俩个数据源masterDataSource,slaveDataSource
<bean id="masterDataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <property name="driverClassName"> <value>${master.jdbc_driverClassName}</value> </property> <property name="url"> <value>${master.jdbc_url}</value> </property> <property name="username"> <value>${master.jdbc_username}</value> </property> <property name="password"> <value>${master.jdbc_password}</value> </property> <!-- 连接池最大使用连接数 --> <property name="maxActive"> <value>40</value> </property> <!-- 初始化连接大小 --> <property name="initialSize"> <value>1</value> </property> <!-- 获取连接最大等待时间 --> <property name="maxWait"> <value>60000</value> </property> <!-- 连接池最小空闲 --> <property name="minIdle"> <value>3</value> </property> <!-- 自动清除无用连接 --> <property name="removeAbandoned"> <value>true</value> </property> <!-- 清除无用连接的等待时间 --> <property name="removeAbandonedTimeout"> <value>180</value> </property> <!-- 连接属性 --> <property name="connectionProperties"> <value>clientEncoding=UTF-8</value> </property> <property name="validationQuery" value="SELECT 1" /> <property name="testWhileIdle" value="true"/> <property name="testOnBorrow" value="false"/> <property name="testOnReturn" value="false"/> <property name="timeBetweenEvictionRunsMillis" value="60000" /> <property name="minEvictableIdleTimeMillis" value="100000"/></bean><bean id = "slaveDataSource" class = "com.alibaba.druid.pool.DruidDataSource" init-method = "init" destroy-method = "close"> <property name = "driverClassName"> <value>${slave.jdbc_driverClassName}</value> </property> <property name = "url"> <value>${slave.jdbc_url}</value> </property> <property name = "username"> <value>${slave.jdbc_username}</value> </property> <property name = "password"> <value>${slave.jdbc_password}</value> </property> <property name = "maxActive"> <value>40</value> </property> <property name = "initialSize"> <value>1</value> </property> <property name = "maxWait"> <value>60000</value> </property> <property name = "minIdle"> <value>3</value> </property> <property name = "removeAbandoned"> <value>true</value> </property> <property name = "removeAbandonedTimeout"> <value>180</value> </property> <property name = "connectionProperties"> <value>clientEncoding=UTF-8</value> </property> <property name="validationQuery" value="SELECT 1" /> <property name="testWhileIdle" value="true"/> <property name="testOnBorrow" value="false"/> <property name="testOnReturn" value="false"/> <property name="timeBetweenEvictionRunsMillis" value="60000" /> <property name="minEvictableIdleTimeMillis" value="100000"/></bean>
配置动态切换
<bean id = "dataSource" class = "com.remair.hx.readwrite.DynamicDataSource"> <property name = "targetDataSources"> <map key-type = "java.lang.String"> <!----> <entry value-ref = "masterDataSource" key = "masterDataSource"></entry> <entry value-ref = "slaveDataSource" key = "slaveDataSource"></entry> </map> </property> <property name = "defaultTargetDataSource" ref = "masterDataSource"></property></bean>开启aop<aop:aspectj-autoproxy proxy-target-class="true"/>配置拦截器<bean id="dataSourceAop" class="com.remair.hx.aspect.DataSourceAop" /><aop:config> <aop:aspect id="c" ref="dataSourceAop"> <aop:pointcut id="tx" expression="execution(* com.remair.hx.api.*.business.*.*(..))"/> <aop:before pointcut-ref="tx" method="before"/> </aop:aspect></aop:config>注意接下来引用的datasource-ref必须是总的dataSource与transactionManager使用一致的dataSource才会生效
<!-- mybatis文件配置,扫描所有mapper文件 --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" p:dataSource-ref="dataSource" p:mapperLocations="classpath:mapper/*.xml"/><!-- configLocation为mybatis属性 mapperLocations为所有mapper --><!-- spring与mybatis整合配置,扫描所有dao --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer" p:basePackage="com.remair.hx.mapper" p:sqlSessionFactoryBeanName="sqlSessionFactory"/><!-- 对数据源进行事务管理 --><!--<bean id="transactionManager1" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"--> <!--p:dataSource-ref="masterDataSource">--> <!--<qualifier value="master"></qualifier>--><!--</bean>--><!--<bean id="transactionManager2" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"--> <!--p:dataSource-ref="slaveDataSource">--> <!--<qualifier value="slave"></qualifier>--><!--</bean>--><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager" p:dataSource-ref="dataSource"> <qualifier value="master"></qualifier></bean><!--<tx:annotation-driven transaction-manager="transactionManager1" proxy-target-class="true"></tx:annotation-driven>--><!--<tx:annotation-driven transaction-manager="transactionManager2" proxy-target-class="true"></tx:annotation-driven>--><tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"></tx:annotation-driven>
springmvc mybatis 多数据源 事务不生效
最新推荐文章于 2024-07-19 10:40:47 发布