<?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:aop="http://www.
springframework.org/schema/aop"
xmlns:cache="http://www.
springframework.org/schema/cache"
xmlns:context="http://www.
springframework.org/schema/context"
xmlns:mvc="http://www.
springframework.org/schema/mvc"
xmlns:oxm="http://www.
springframework.org/schema/oxm"
xmlns:p="http://www.
springframework.org/schema/p"
xmlns:tx="http://www.
springframework.org/schema/tx"
xmlns:task="http://www.
springframework.org/schema/task"
xsi:schemaLocation="http://www.
springframework.org/schema/beans http://www.
springframework.org/schema/beans/
spring-beans
-4.1.xsd
http://www.
springframework.org/schema/aop http://www.
springframework.org/schema/aop/
spring-aop
-4.1.xsd
http://www.
springframework.org/schema/cache http://www.
springframework.org/schema/cache/
spring-cache
-4.1.xsd
http://www.
springframework.org/schema/context http://www.
springframework.org/schema/context/
spring-context
-4.1.xsd
http://www.
springframework.org/schema/mvc http://www.
springframework.org/schema/mvc/
spring-mvc
-4.1.xsd
http://www.
springframework.org/schema/oxm http://www.
springframework.org/schema/oxm/
spring-oxm
-4.1.xsd
http://www.
springframework.org/schema/tx http://www.
springframework.org/schema/tx/
spring-tx
-4.1.xsd
http://www.
springframework.org/schema/task http://www.
springframework.org/schema/task/
spring-task
-4.1.xsd">
<!
-- 使用缓存annotation 配置
-->
<!
-- <cache:annotation
-driven cache
-manager="ehCacheManager" />
-->
<mvc:default
-servlet
-handler/>
<bean id="propertyConfigurer"
class="org.
springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>classpath:jdbc.properties</value>
</list>
</property>
</bean>
<bean id="masterSource" class="com.alibaba.druid.pool.DruidDataSource"
init
-method="init" destroy
-method="close">
<property name="driverClassName">
<value>${jdbc.driverClassName}</value>
</property>
<property name="url">
<value>${jdbc.url.master}</value>
</property>
<property name="username">
<value>${jdbc.username.master}</value>
</property>
<property name="password">
<value>${jdbc.password.master}</value>
</property>
<!
-- 连接池最大使用连接数
-->
<property name="maxActive">
<value>50</value>
</property>
<!
-- 初始化连接大小
-->
<property name="initialSize">
<value>1</value>
</property>
<!
-- 获取连接最大等待时间
-->
<property name="maxWait">
<value>60000</value>
</property>
<!
-- 连接池最大空闲
-->
<!
-- <property name="maxIdle">
<value>20</value>
</property>
-->
<!
-- 连接池最小空闲
-->
<property name="minIdle">
<value>30</value>
</property>
<property name="testWhileIdle">
<value>
true</value>
</property>
<property name="validationQuery">
<value>select 1 from dual</value>
</property>
<!
-- 自动清除无用连接
-->
<property name="removeAbandoned">
<value>
true</value>
</property>
<!
-- 清除无用连接的等待时间
-->
<property name="removeAbandonedTimeout">
<value>90</value>
</property>
<!
-- 连接属性
-->
<property name="connectionProperties">
<value>clientEncoding=UTF
-8</value>
</property>
<!
-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
-->
<property name="timeBetweenEvictionRunsMillis">
<value>60000</value>
</property>
<!
-- 配置一个连接在池中最小生存的时间，单位是毫秒
-->
<property name="minEvictableIdleTimeMillis">
<value>300000</value>
</property>
</bean>
<bean id="slaveSource" class="com.alibaba.druid.pool.DruidDataSource"
init
-method="init" destroy
-method="close">
<property name="driverClassName">
<value>${jdbc.driverClassName}</value>
</property>
<property name="url">
<value>${jdbc.url.slave}</value>
</property>
<property name="username">
<value>${jdbc.username.slave}</value>
</property>
<property name="password">
<value>${jdbc.password.slave}</value>
</property>
<!
-- 连接池最大使用连接数
-->
<property name="maxActive">
<value>50</value>
</property>
<!
-- 初始化连接大小
-->
<property name="initialSize">
<value>1</value>
</property>
<!
-- 获取连接最大等待时间
-->
<property name="maxWait">
<value>60000</value>
</property>
<!
-- 连接池最大空闲
-->
<!
-- <property name="maxIdle">
<value>20</value>
</property>
-->
<!
-- 连接池最小空闲
-->
<property name="minIdle">
<value>30</value>
</property>
<property name="testWhileIdle">
<value>
true</value>
</property>
<property name="validationQuery">
<value>select 1 from dual</value>
</property>
<!
-- 自动清除无用连接
-->
<property name="removeAbandoned">
<value>
true</value>
</property>
<!
-- 清除无用连接的等待时间
-->
<property name="removeAbandonedTimeout">
<value>90</value>
</property>
<!
-- 连接属性
-->
<property name="connectionProperties">
<value>clientEncoding=UTF
-8</value>
</property>
<!
-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
-->
<property name="timeBetweenEvictionRunsMillis">
<value>60000</value>
</property>
<!
-- 配置一个连接在池中最小生存的时间，单位是毫秒
-->
<property name="minEvictableIdleTimeMillis">
<value>300000</value>
</property>
</bean>
<bean id="dynamicDataSource" class="com.s
jsemi.rrc.datasource.DynamicDataSource">
<property name="targetDataSources">
<map key
-type="
java.lang.String">
<entry key="master" value
-ref="masterSource"/>
<entry key="slave" value
-ref="slaveSource"/>
</map>
</property>
<!
-- 默认数据源
-->
<property name="defaultTargetDataSource" ref="masterSource"></property>
</bean>
<bean id="jdbcTemplate" class="org.
springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dynamicDataSource"/>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.
spring.SqlSessionFactoryBean">
<!
-- 注入
数据库连接池
-->
<property name="dataSource" ref="dynamicDataSource"/>
<!
-- 配置myBatis全局配置文件:mybatis
-config.xml
-->
<property name="configLocation" value="classpath:mybatis
-config.xml"/>
<!
-- 扫描entity包 使用别名
-->
<property name="typeAliasesPackage" value="com.s
jsemi.rrc.entity"/>
<!
-- 扫描sql配置文件:mapper需要的xml文件
-->
<property name="mapperLocations" value="classpath*:com/s
jsemi/rrc/mybatis/**/*Mapper.xml"/>
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageInterceptor">
<property name="properties">
<value>
helpDialect = oracle
</value>
</property>
</bean>
</array>
</property>
</bean>
<context:component
-scan base
-package="com.s
jsemi.rrc">
<context:exclude
-filter type="annotation" expression="org.
springframework.stereotype.Controller"/>
</context:component
-scan>
<task:annotation
-driven scheduler="taskScheduler" mode="proxy"/>
<task:scheduler id="taskScheduler" pool
-size="10"/>
<!
-- 文件上传解析器
-->
<bean id="multipartResolver" class="org.
springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="defaultEncoding" value="utf
-8"/>
</bean>
<!
-- 扫描basePackage下所有的接口类，根据对应的mapper.xml为其生成代理类
-->
<bean class="org.mybatis.
spring.mapper.MapperScannerConfigurer">
<!
-- 注入sqlSessionFactory
-->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<!
-- 给出需要扫描Dao接口包
-->
<property name="basePackage" value="com.s
jsemi.rrc.mybatis.mapper"/>
</bean>
<bean id="sqlSession" class="org.mybatis.
spring.SqlSessionTemplate">
<constructor
-arg index="0" ref="sqlSessionFactory"></constructor
-arg>
</bean>
<!
-- 配置
事务管理器
-->
<bean name="transactionManager" class="org.
springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dynamicDataSource"></property>
</bean>
<!
-- 注解方式配置
事务 -->
<tx:annotation
-driven transaction
-manager="transactionManager" proxy
-target
-class="
true"/>
<tx:advice id="transactionAdvice" transaction
-manager="transactionManager">
<tx:attributes>
<tx:method name="add*" propagation="REQUIRED" rollback
-for="
java.lang.Throwable"/>
<tx:method name="append*" propagation="REQUIRED"/>
<tx:method name="insert*" propagation="REQUIRED"/>
<tx:method name="save*" propagation="REQUIRED"/>
<tx:method name="creat*" propagation="REQUIRED"/>
<tx:method name="update*" propagation="REQUIRED"/>
<tx:method name="modify*" propagation="REQUIRED"/>
<tx:method name="edit*" propagation="REQUIRED"/>
<tx:method name="delete*" propagation="REQUIRED"/>
<tx:method name="remove*" propagation="REQUIRED"/>
<tx:method name="repair" propagation="REQUIRED"/>
<tx:method name="delAndRepair" propagation="REQUIRED"/>
<tx:method name="get*"
read-only="
true"/>
<tx:method name="query*"
read-only="
true"/>
<tx:method name="select*"
read-only="
true"/>
<tx:method name="find*"
read-only="
true"/>
<tx:method name="load*"
read-only="
true"/>
<tx:method name="search*"
read-only="
true"/>
<tx:method name="datagrid*"
read-only="
true"/>
<tx:method name="*" propagation="SUPPORTS"/>
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut id="transactionPointcut" expression="execution(* com.s
jsemi.rrc.service.impl.*.*(..))"/>
<aop:advisor pointcut
-ref="transactionPointcut" advice
-ref="transactionAdvice"/>
</aop:config>
<aop:aspectj
-autoproxy proxy
-target
-class="
true"/>
<bean id="dataSourceAspect" class="com.s
jsemi.rrc.datasource.DataSourceAspect"/>
<aop:config>
<aop:pointcut id="dataSourcePointcut" expression="execution(* com.s
jsemi.rrc.service.impl.*.*(..))"/>
<aop:advisor pointcut
-ref="dataSourcePointcut" advice
-ref="dataSourceAspect" order="1"/>
</aop:config>
</beans>
本文详细解释了只读事务的概念及其应用场景，特别是在多条查询语句同时执行时如何保证数据的一致性。此外还介绍了在不同环境下如何设置只读事务。
扫一扫
398
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
