最近做项目,被一个问题烦恼了很久。使用Spring MVC+Spring +Hibernate开发项目,在使用注解配置事务管理,刚开始发现无论如何数据库都无法更新,但是可以从数据库查询到数据。怀疑是配置文件的问题,但是反复确认,配置文件没有问题。后来将注解配置事务变更为注解配置事务,同样无法入库。
后来在dao层方法里面添加了session.flush()数据可以入库,但是不能回滚。正常的情况下,配置事务成功的话,事务会自动提交,session会自动flush。于是怀疑配置的事务根本就没有起到作用。在网上查找资料,终于发现问题症结所在。
引起问题原因:spring初始化时优先component-scan bean,注入Web Controller 的Service直接拿了上下文中的@Service("someService"),这个时候@Transactional (readOnly=false, isolation = Isolation.READ_COMMITTED) 还没有被处理.所以Web Controller 的Service是SomeServiceImpl而不是AOP的$ProxyNO.
解决途径:不让spring扫描到ServiceImpl类,直接写在xml文件,其它的配置和annotation照用,这样事务就起作用了.
按照上述配置,发现事务起作用了,自动提交,并且在出现异常的时候自动回滚。
工程具体配置:
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0"> <display-name>SMS</display-name> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath*:school-spring-*.xml</param-value> </context-param> <listener> <!-- 负责加载spring的配置文件 --> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!-- 直接使用spring的encodingFilter--> <filter> <filter-name>encodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> <init-param> <param-name>forceEncoding</param-name> <param-value>true</param-value> </init-param> </filter> <filter-mapping> <filter-name>encodingFilter</filter-name> <url-pattern>*</url-pattern> </filter-mapping> <!-- 集成使用Spring MVC --> <servlet> <servlet-name>defaultDispatcher</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <!-- Spring XML 文件 --> <param-value>classpath*:school-springmvc.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>defaultDispatcher</servlet-name> <url-pattern>/school/*</url-pattern> </servlet-mapping> <!-- 验证码生成 --> <servlet> <servlet-name>image_code</servlet-name> <servlet-class>cn.com.yinuo.common.web.util.RandomCode</servlet-class> </servlet> <servlet-mapping> <servlet-name>image_code</servlet-name> <url-pattern>/imgCode</url-pattern> </servlet-mapping> <!-- 解决hibernate延迟加载问题 --> <!-- <filter> <filter-name>openSession</filter-name> <filter-class>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class> </filter> <filter-mapping> <filter-name>openSession</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> --> <!-- session超时定义,单位为分钟 --> <session-config> <session-timeout>30</session-timeout> </session-config> <!-- 欢迎界面 --> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> </web-app>
web.xml
<?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:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:jee="http://www.springframework.org/schema/jee" xsi:schemaLocation= "http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.2.xsd"> <!-- Spring管理配置文件 --> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>classpath*:school_config.properties</value> </list> </property> <!-- 可注入中文 --> <property name="fileEncoding" value="UTF-8"/> </bean> <!-- 注解扫描包 会扫描school包下面所有的类文件以及包 待确认--> <context:component-scan base-package="cn.com.yinuo.school"> <context:exclude-filter type="regex" expression="cn.com.yinuo.*.web.*"/> <context:exclude-filter type="regex" expression=".*ServiceImpl$" /> </context:component-scan> <!-- 配置multipartResolver处理器 --> <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> <property name="defaultEncoding" value="utf-8" /> <property name="maxUploadSize" value="10485760000" /> <property name="maxInMemorySize" value="40960" /> </bean> <bean name="informationService" class="cn.com.yinuo.school.InformationMaintenance.biz.service.impl.InformationServiceImpl"> </bean> </beans>
school-spring-core.xml
<?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:p="http://www.springframework.org/schema/p" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation= "http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd"> <!-- 注解扫描包 会扫描school包下面所有的类文件以及包 待确认--> <context:component-scan base-package="cn.com.yinuo.school"> <!-- <context:include-filter type="regex" expression="cn.com.yinuo.*.web.*"/> --> </context:component-scan> <!-- 开启注解 --> <mvc:annotation-driven/> <!-- 上面开启注解的方式是下面开启注解方式的优化,下面的方式在3之后就过时了 --> <!-- <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" /> <bean class="org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping"></bean> --> <!-- 访问静态资源 --> <mvc:resources location="/js/" mapping="/js/**"/> <mvc:resources location="/img/" mapping="/img/**"/> <mvc:resources location="/css/" mapping="/css/**"/> <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="/"></property> <property name="suffix" value=".jsp"></property> </bean> </beans>
school-springmvc.xml
<?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:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation= "http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd"> <!-- Spring管理 Hibernate --> <!-- 配置DataSource --> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${jdbc.driverClassName}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> <property name="initialSize" value="${initialSize}"/> <property name="maxActive" value="${maxActive}"/> <property name="maxIdle" value="${maxIdle}"/> <property name="minIdle" value="${minIdle}"/> </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="packagesToScan"> <list> <value>cn.com.yinuo.school.model.domain</value> </list> </property> <property name="mappingResources"> <list> <value>../resources/${resource.mapping.sql}</value> </list> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">${hibernate.dialect}</prop> <prop key="hibernate.show_sql">${hibernate.show_sql}</prop> <prop key="hibernate.generate_statistics">${hibernate.generate_statistics}</prop> <prop key="hibernate.format_sql">${hibernate.format_sql}</prop> <prop key="hibernate.use_sql_comments">${hibernate.use_sql_comments}</prop> <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop> <!-- <prop key="hibernate.connection.autocommit">${hibernate.connection.autocommit}</prop> --> <prop key="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</prop> <prop key="hibernate.cache.use_second_level_cache">true</prop> <prop key="Hibernate.current_session_context_class">thread</prop> <prop key="hibernate.cache.use_query_cache">false</prop> <prop key="hibernate.connection.release_mode">after_transaction</prop> </props> </property> </bean> <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory"/> </bean> <context:annotation-config/> <aop:aspectj-autoproxy proxy-target-class="true"/> <aop:config proxy-target-class="true"> </aop:config> <!-- 注解配置事务--> <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true" /> <!-- <tx:advice id="txAdvice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="add*" propagation="REQUIRED" read-only="false" rollback-for="Exception" /> <tx:method name="update*" propagation="REQUIRED" read-only="false"/> <tx:method name="insert*" propagation="REQUIRED" read-only="false"/> <tx:method name="modify*" propagation="REQUIRED" read-only="false"/> <tx:method name="delete*" propagation="REQUIRED" read-only="false"/> <tx:method name="get*" propagation="REQUIRED" /> <tx:method name="save*" propagation="REQUIRED" read-only="false"/> </tx:attributes> </tx:advice> <aop:config> <aop:pointcut id="interceptorPointCuts" expression="execution(* cn.com.yinuo.school.InformationMaintenance.biz.service.impl.InformationServiceImpl.*(..))" /> <aop:advisor advice-ref="txAdvice" pointcut-ref="interceptorPointCuts" /> </aop:config> --> </beans>
school-spring-hibernate.xml
package cn.com.yinuo.school.InformationMaintenance.web; import java.io.IOException; import java.io.PrintWriter; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import net.sf.json.JSONObject; import org.apache.log4j.Logger; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import cn.com.yinuo.school.InformationMaintenance.biz.service.InformationService; import cn.com.yinuo.school.model.domain.Student; import cn.com.yinuo.school.util.Json; @Controller @RequestMapping("/information") public class InformationController { @Autowired private InformationService informationService; private static Logger logger=Logger.getLogger(InformationController.class); @RequestMapping("/toRegister") public String toRegister(){ return "JSP/imformation/register"; } @RequestMapping("/addUser") public Json addUser(HttpServletRequest request,HttpServletResponse response){ Student student=new Student(); student.setName("阿享"); student.setClassId("001001"); student.setCreditId("4365671235678931"); student.setMailBox("591137758@qq.com"); student.setGender(0); student.setPassword("janeyloveachris"); student.setType(1); informationService.addUser(student); Json json=new Json(); json.setSuccess(true); json.setMsg("新增成功"); response.setCharacterEncoding("UTF-8"); response.setContentType("application/json; charset=utf-8"); PrintWriter pw=null; JSONObject jsonObject =JSONObject.fromObject(json); try { pw=response.getWriter(); pw.append(jsonObject.toString()); logger.debug("返回到前台的对象是"+jsonObject.toString()); } catch (IOException e) { e.printStackTrace(); }finally{ if(pw!=null){ pw.close(); } } return null; } }
InformationController.java
package cn.com.yinuo.school.InformationMaintenance.biz.service.impl; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Propagation; import org.springframework.transaction.annotation.Transactional; import cn.com.yinuo.school.InformationMaintenance.biz.dao.InformationDao; import cn.com.yinuo.school.InformationMaintenance.biz.service.InformationService; @Transactional @Service public class InformationServiceImpl implements InformationService { @Autowired private InformationDao informationDao; @Transactional(propagation=Propagation.REQUIRED,rollbackFor=java.lang.Exception.class,readOnly=false) @Override public void addUser(Object object) { informationDao.addUser(object); } @Override public Object getAllUsers() { return informationDao.getAllUsers(); } }
InformationServiceImpl.java
package cn.com.yinuo.school.InformationMaintenance.biz.dao.impl; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import cn.com.yinuo.school.InformationMaintenance.biz.dao.InformationDao; import cn.com.yinuo.school.model.domain.Student; import cn.com.yinuo.school.model.domain.Teacher; @Repository public class InformationDaoImpl /*extends HibernateDaoSupport */implements InformationDao { @Autowired private SessionFactory sessionFactory; private Logger logger=LoggerFactory.getLogger(InformationDaoImpl.class); @Override public void addUser(Object object) { /*Session session=sessionFactory.openSession(); Transaction tc=session.beginTransaction();*/ Session session=sessionFactory.getCurrentSession(); //tc.begin(); if(object instanceof Student){ //getHibernateTemplate().save((Student)object); //sessionFactory.getCurrentSession().save((Student)object); session.saveOrUpdate((Student)object); }else if(object instanceof Teacher){ //getHibernateTemplate().save((Teacher)object); session.save((Teacher)object); } //tc.commit(); //session.flush(); System.out.println((1/0)); } @Override public Object getAllUsers() { //super.getHibernateTemplate().find(""); Student st=new Student(); Query query=sessionFactory.openSession().createQuery("from "+st.getClass().getName()); logger.debug(query.getQueryString()); return query.list(); } }
InformationDaoImpl.java
后来师父找到了我的问题所在:在springmvc.xml在扫描包的时候缺少了:use-default-filters="false"
<context:component-scan base-package="cn.com.yinuo.school" use-default-filters="false" > <context:include-filter type="regex" expression="cn.com.yinuo.*.web.*Controller$"/> </context:component-scan>
添加之后,去掉spring-core.xml中的
<context:component-scan base-package="cn.com.yinuo.school"> <context:exclude-filter type="regex" expression="cn.com.yinuo.*.web.*Controller$"/> <!-- <context:exclude-filter type="regex" expression=".*ServiceImpl$" /> --> </context:component-scan>
以及service的配置执行发现事务同样起到作用了。
去掉我的其他配置,同时不加use-default-filters="false",会报错 session没有绑定。
师父参照的博客文章地址:http://blog.csdn.net/shuwei003/article/details/7281792