@Transactional Spring MyBatis不工作

Question

我有一个spring webapp，一切都很好，但现在我需要一个事务性方法，

这是我的应用程序上下文。xml

<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:beans="http://www.springframework.org/schema/beans"
    xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
    xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

    <!-- DispatcherServlet Context: defines this servlet's request-processing 
        infrastructure -->

    <!-- Enables the Spring MVC @Controller programming model -->
    <annotation-driven />

    <!-- Bean para Nombre de Cliente -->

    <!-- Handles HTTP GET requests for /resources/** by efficiently serving 
        up static resources in the ${webappRoot}/resources directory -->
    <resources mapping="/resources/**" location="/resources/" />

    <!-- Resolves views selected for rendering by @Controllers to .jsp resources 
        in the /WEB-INF/views directory -->
   <beans:bean
        class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <beans:property name="prefix" value="/WEB-INF/views/" />
        <beans:property name="suffix" value=".jsp" />
    </beans:bean>

    <beans:bean id="messageSource"
        class="org.springframework.context.support.ReloadableResourceBundleMessageSource">
        <beans:property name="basename" value="classpath:mensajes" />
        <beans:property name="defaultEncoding" value="UTF-8" />
    </beans:bean>

    <beans:bean id="localeResolver"
        class="org.springframework.web.servlet.i18n.CookieLocaleResolver">
        <beans:property name="defaultLocale" value="es" />
        <beans:property name="cookieName" value="myAppLocaleCookie"></beans:property>
        <beans:property name="cookieMaxAge" value="3600"></beans:property>
    </beans:bean>


    <interceptors>
        <beans:bean id="localeChangeInterceptor"
            class="org.springframework.web.servlet.i18n.LocaleChangeInterceptor">
            <beans:property name="paramName" value="locale" />
        </beans:bean>
    </interceptors>

    <context:component-scan base-package="com.web.*" />
    <context:component-scan base-package="com.*" />

</beans:beans>

这是我的数据库。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:c="http://www.springframework.org/schema/c" xmlns:tx="http://www.springframework.org/schema/tx"

    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">


    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
        p:location="monitor-properties/monitor.properties" />


    <bean class="org.mybatis.spring.transaction.SpringManagedTransactionFactory"
        id="springManagedTransactionFactory">
    </bean>

 <!-- 
 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <property name="dataSource" ref="dataSource" />
</bean>
 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="mapperLocations" value="classpath:com/*/database/*.xml" />
        <property name="dataSource" ref="dataSource" />
        <property name="transactionFactory" ref="springManagedTransactionFactory" />
    </bean>

    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg index="0" ref="sqlSessionFactory" />
    </bean>

    <bean id="adminSaveSettings" class="com.SaveSettings">
        <property name="sqlSession" ref="sqlSession" />
    </bean>

    <!-- ORACLE -->
 <bean id="dataSource" class="com.CustomBasicDataSource" 
        p:driverClassName="${oracle.driverClassName}" p:url="${oracle.url}" p:username="${oracle.username}" 
        p:password="${oracle.password}" />

在一个服务类中，我有一个autowired属性，这个属性有一个这样的事务方法：我进行更新，将一行值更改为“2”，然后在抛出RuntimeException之后，如果一切正常，则必须回滚更新。

public class SaveSettings {

    protected final Logger logger = LoggerFactory.getLogger(getClass());

    private SqlSession sqlSession;


    public SqlSession getSqlSession() {
        return sqlSession;
    }


    public void setSqlSession(SqlSession sqlSession) {
        this.sqlSession = sqlSession;
    }


    @Transactional(readOnly=false,rollbackFor=Exception.class)
    public int saveNewSettings(WebServer settings) {
        AdminPanelMapper qmap = sqlSession.getMapper(AdminPanelMapper.class);
        int inserted = 0;
        qmap.updateTo2();

        throw new NullPointerException();
    }
}

两天前，我尝试了很多可能的解决方案，我在google和stackoverflow中找到了，但它从来没有运行良好。database.xmltransactionManager是注释，因为我正在尝试我找到的其他示例。

如果你想要更多关于我的问题的信息，我会给你更多的细节，问我。对不起，如果我没有解释清楚。

谢谢大家！

编辑：

如果我为transactionManager bean编写并退出注释，则会出现错误。

ERROR: org.springframework.web.context.ContextLoader `- Context initialization failed org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 9 in XML document from ServletContext resource [/WEB-INF/spring/database.xml] is invalid; nested exception is org.xml.sax.SAXParseException; lineNumber: 9; columnNumber: 65; cvc-complex-type.2.4.c: El comodín coincidente es estricto, pero no se ha encontrado ninguna declaración para el elemento 'tx:annotation-driven'.`

Answer 1

我也遇到了同样的问题。我通过在类定义中添加@Transactional注释来解决这个问题。

@Transactional
public class SaveSettings {
    ...
    @Transactional(readOnly=false,rollbackFor=Exception.class)
    public int saveNewSettings(WebServer settings) {
        ...
    }
}

Answer 2

我在您的xml的事务本身配置中看不到。你没忘记放在那里吗：

<tx:annotation-driven transaction-manager="transactionManager"/>

请注意，这是不同于spring-mvc的东西。