框架 druid 、spring 4.1.3 、mybatis 3.2.8
访问时日志打印
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6429f8f2] was not registered for synchronization because synchronization is not active
2017-10-21 10:22:53,647 [http-bio-8088-exec-3] [com.alibaba.druid.pool.DruidDataSource]-[ERROR] testWhileIdle is true, validationQuery not set
2017-10-21 10:22:53,659 [http-bio-8088-exec-3] [com.alibaba.druid.pool.DruidDataSource]-[INFO] {dataSource-1} inited
JDBC Connection [ConnectionID:1 ClientConnectionId: 3ce6b337-3246-4db3-8edd-dcaabbe19925] will not be managed by Spring
同事事务也不生效
事务配置
<!-- 事务管理器 -->
<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="save*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/>
<tx:method name="insert*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/>
<tx:method name="add*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/>
<tx:method name="create*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/>
<tx:method name="delete*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/>
<tx:method name="update*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/>
<tx:method name="find*" propagation="SUPPORTS" read-only="true" />
<tx:method name="select*" propagation="SUPPORTS" read-only="true" />
<tx:method name="get*" propagation="SUPPORTS" read-only="true" />
<tx:method name="list*" propagation="SUPPORTS" read-only="true" />
</tx:attributes>
</tx:advice>
<!-- 切面 -->
<aop:config>
<aop:advisor advice-ref="txAdvice"
pointcut="execution(* com.ciguo.service.*.*(..))" />
</aop:config>
数据库连接配置
<!-- 数据库连接池 -->
<!-- 加载配置文件 -->
<context:property-placeholder location="classpath:resource/*.properties" />
<!-- 配置扫描包,加载mapper代理对象 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.ciguo.mapper"></property>
<property name="sqlSessionTemplateBeanName" value="sqlSessionTemplate"></property>
</bean>
<!-- 数据库连接池 -->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
destroy-method="close">
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="driverClassName" value="${jdbc.driver}" />
<property name="maxActive" value="10" />
<property name="minIdle" value="5" />
</bean>
<!-- 配置sqlsessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml"></property>
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 创建一个sqlSession实例,线程安全的,可以在所有DAO实例共享,原理是将sqlSession,事务与当前线程挂钩 -->
<bean name="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate" destroy-method="close" scope="prototype">
<constructor-arg index="0" ref="sqlSessionFactory" />
</bean>
调试很久没排查到错误,最后想到是不是配置切点扫描表达式的问题,仔细看了切点表达式
execution(* com.ciguo.service.*.*(..))
这种写法是扫描到service下一级*.java里面的方法,显然是找不到的,于是乎改成
execution(* com.ciguo.service.*.impl.*.*(..))
impl后面第一个 * 表示Java类,第二个 * 表示方法 这样子就能扫描到了,重启测试,
Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1827f65a]
2017-10-21 10:38:48,126 [http-bio-8088-exec-3] [com.alibaba.druid.pool.DruidDataSource]-[ERROR] testWhileIdle is true, validationQuery not set
2017-10-21 10:38:48,140 [http-bio-8088-exec-3] [com.alibaba.druid.pool.DruidDataSource]-[INFO] {dataSource-1} inited
JDBC Connection [ConnectionID:1 ClientConnectionId: a66941f8-3f93-4b13-9946-45de09c9b1d8] will be managed by Spring
SqlSession现在已经被spring管理了,事务也生效了