spring拦截器引起的问题

背景：

      在使用SpringMVC+iBatis开发中，今日出现了以下异常：

2016-03-04 16:03:04 ERROR [http-apr-8080-exec-8] org.codehaus.xfire.handler.DefaultFaultHandler  - Fault occurred!org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-onlyat org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:717)at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)at com.sdzn.service.LessonPreExamGroupService$$EnhancerByCGLIB$$28860f76.getResExamGroup(<generated>)at com.sdzn.web.service.soap.Service.chooseCourse(Service.java:763)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:606)at org.codehaus.xfire.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:59)at org.codehaus.xfire.service.binding.ServiceInvocationHandler.sendMessage(ServiceInvocationHandler.java:320)at org.codehaus.xfire.service.binding.ServiceInvocationHandler$1.run(ServiceInvocationHandler.java:86)at org.codehaus.xfire.service.binding.ServiceInvocationHandler.execute(ServiceInvocationHandler.java:134)at org.codehaus.xfire.service.binding.ServiceInvocationHandler.invoke(ServiceInvocationHandler.java:109)at org.codehaus.xfire.handler.HandlerPipeline.invoke(HandlerPipeline.java:131)at org.codehaus.xfire.transport.DefaultEndpoint.onReceive(DefaultEndpoint.java:64)at org.codehaus.xfire.transport.AbstractChannel.receive(AbstractChannel.java:38)at org.codehaus.xfire.transport.http.XFireServletController.invoke(XFireServletController.java:304)at org.codehaus.xfire.transport.http.XFireServletController.doService(XFireServletController.java:129)at org.codehaus.xfire.transport.http.XFireServlet.doPost(XFireServlet.java:116)at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:76)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2466)at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2455)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Thread.java:745)

可以看到，是因为事务控制引起的数据库回滚操作，并且事务是限制了只读操作，于是想到了事务配置管理器，看一下代码：

<!-- 定义JDBC事务管理器 --><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource" /></bean><tx:annotation-driven transaction-manager="transactionManager"/> <tx:advice id="txAdvice" transaction-manager="transactionManager">       <tx:attributes>     <tx:method name="get*" read-only="true"/>  <tx:method name="add*" propagation="REQUIRED" read-only="false" rollback-for="Throwable"/>      <tx:method name="insert*" propagation="REQUIRED" read-only="false" rollback-for="Throwable"/>  <tx:method name="delete*" propagation="REQUIRED" read-only="false" rollback-for="Throwable"/>  <tx:method name="update*" propagation="REQUIRED" read-only="false" rollback-for="Throwable"/>  <tx:method name="modify*" propagation="REQUIRED" read-only="false" rollback-for="Throwable"/>  <tx:method name="select*" propagation="REQUIRED" read-only="false" rollback-for="Throwable"/>  <tx:method name="write*" propagation="REQUIRES_NEW" read-only="false" rollback-for="Throwable"/>  </tx:attributes>  </tx:advice>

在查看出错的方法，果然，方法名是：

因为在这个方法里用到了更新操作，于是引起了此问题，将get改为query之后，问题解决。

留此希望能帮助遇到同样问题的人。