@Query 事务问题，Executing an update/delete query

新搭建了一个 Spring MVC+Spring Data JPA+Hibernate的一个工程
在DAO的方法之上加了注解@Query、@Modifying，但是在运行过程中一直抛出
javax.persistence.TransactionRequiredException: Executing an update/delete query 的异常，实在无力了，希望有大大来帮助
2015-04-29 23:44:12,534[INFO ]com.mchange.v2.log.MLog:MLog clients using slf4j logging.
2015-04-29 23:44:12,747[INFO ]com.mchange.v2.c3p0.C3P0Registry:Initializing c3p0-0.9.5 [built 02-January-2015 13:25:04 -0500; debug? true; trace: 10]
2015-04-29 23:44:13,142[INFO ]org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean:Building JPA container EntityManagerFactory for persistence unit 'elev'
2015-04-29 23:44:14,041[INFO ]com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource:Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hgeby9991mfjmq1wjzcl2|66c88fce, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceUseNamedDriverClass -> false, identityToken -> 1hgeby9991mfjmq1wjzcl2|66c88fce, idleConnectionTestPeriod -> 0, initialPoolSize -> 20, jdbcUrl -> jdbc:mysql://localhost:3306/elev, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 45, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
2015-04-29 23:44:15,422[DEBUG]org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler:Creating new EntityManager for shared EntityManager invocation
2015-04-29 23:44:15,496[DEBUG]org.springframework.orm.jpa.EntityManagerFactoryUtils:Closing JPA EntityManager
2015-04-29 23:44:15,521[DEBUG]org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler:Creating new EntityManager for shared EntityManager invocation
2015-04-29 23:44:15,521[DEBUG]org.springframework.orm.jpa.EntityManagerFactoryUtils:Closing JPA EntityManager
2015-04-29 23:44:15,763[DEBUG]org.springframework.transaction.annotation.AnnotationTransactionAttributeSource:Adding transactional method 'BusinessUserServiceImpl.editUser' with attribute: PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED; 'transactionManager'
2015-04-29 23:44:15,982[DEBUG]org.springframework.transaction.annotation.AnnotationTransactionAttributeSource:Adding transactional method 'BusinessUserServiceImpl.editUser' with attribute: PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED; 'transactionManager'
从日志上看，好像事务已经加上了。。。
以下是工程部分代码：
applicationContext-main.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:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="
        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">
    <context:annotation-config/>
    <context:component-scan base-package="com.feinno">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
    <import resource="applicationContext-profile.xml"/>
    <import resource="applicationContext-jpa.xml"/>
    <import resource="applicationContext-mvc.xml"/>

</beans>

applicationContext-mvc.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:mvc="http://www.springframework.org/schema/mvc"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd">
    <context:component-scan base-package="com.feinno">
        <context:include-filter type="annotation"
            expression="org.springframework.stereotype.Controller" />
    </context:component-scan>
    <mvc:annotation-driven>
        <mvc:message-converters register-defaults="true">
            <bean
                class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
                <property name="prettyPrint" value="true" />
                <property name="supportedMediaTypes">
                    <list>
                        <value>application/json</value>
                        <value>text/html</value>
                    </list>
                </property>
            </bean>
        </mvc:message-converters>
    </mvc:annotation-driven>
</beans>

applicationContext-profile.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:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="
        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">
    <beans profile="dev">
        <context:property-placeholder
            ignore-resource-not-found="true" location="classpath:/config/dev.properties" />
        <bean id="configProperties"
            class="org.springframework.beans.factory.config.PropertiesFactoryBean">
            <property name="locations">
                <list>
                    <value>classpath:/config/dev.properties</value>
                </list>
            </property>
        </bean>
    </beans>
    <beans profile="test">
        <context:property-placeholder
            ignore-resource-not-found="true" location="classpath:/config/test.properties" />
        <bean id="configProperties"
            class="org.springframework.beans.factory.config.PropertiesFactoryBean">
            <property name="locations">
                <list>
                    <value>classpath:/config/test.properties</value>
                </list>
            </property>
        </bean>
    </beans>
    <beans profile="pro">
        <context:property-placeholder
            ignore-resource-not-found="true" location="classpath:/config/prod.properties" />
        <bean id="configProperties"
            class="org.springframework.beans.factory.config.PropertiesFactoryBean">
            <property name="locations">
                <list>
                    <value>classpath:/config/prod.properties</value>
                </list>
            </property>
        </bean>
    </beans>
    <beans>
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
            destroy-method="close">
            <property name="driverClass" value="${jdbc.driver}" />
            <property name="jdbcUrl" value="${jdbc.url}" />
            <property name="user" value="${jdbc.user}" />
            <property name="password" value="${jdbc.password}" />
            <property name="minPoolSize" value="10" />
            <property name="maxPoolSize" value="45" />
            <property name="initialPoolSize" value="20" />
        </bean>
    </beans>
</beans>

applicationContext-jpa.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:context="http://www.springframework.org/schema/context"
    xmlns:jpa="http://www.springframework.org/schema/data/jpa" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xsi:schemaLocation="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 http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
    <jpa:repositories base-package="com.feinno.elev.interfaces" transaction-manager-ref="transactionManager" entity-manager-factory-ref="entityManagerFactory" />
    <bean id="entityManagerFactory"
        class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="persistenceUnitName" value="elev" />
        <property name="jpaVendorAdapter">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
                <property name="generateDdl" value="false" />
                <property name="showSql" value="false" />
                <property name="databasePlatform" value="org.hibernate.dialect.MySQL5Dialect" />
                <property name="database" value="MYSQL" />

            </bean>
        </property>
        <property name="jpaProperties">
            <props>
                <prop key="hibernate.format_sql">true</prop>
            </props>
        </property>
        <property name="packagesToScan">
            <list>
                <value>com.feinno.elev.interfaces.model</value>
            </list>
        </property>
    </bean>
    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="dataSource" ref="dataSource" />
        <property name="entityManagerFactory" ref="entityManagerFactory" />
        <property name="jpaDialect">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect"></bean>
        </property>
    </bean>
    <tx:annotation-driven proxy-target-class="true" transaction-manager="transactionManager" />
</beans>

Dao

 package com.feinno.elev.interfaces.business.dao;


import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import com.feinno.elev.interfaces.model.BusinessUser;

@Repository
public interface BusinessUserDao extends JpaRepository<BusinessUser, String> {
    @Modifying
    @Query("update BusinessUser set password='123456' where userName=?1")
    public void edit(String userName);

    @Modifying
    @Query(value="delete from sys_accesspro where accessuser = ?1",nativeQuery=true)
    public void delete(String userName);
}

Service

 package com.feinno.elev.interfaces.business.service.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Isolation;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import com.feinno.elev.interfaces.business.dao.BusinessUserDao;
import com.feinno.elev.interfaces.business.service.BusinessUserService;
import com.feinno.elev.interfaces.model.BusinessUser;
import com.feinno.elev.util.CommonUtil;
@Service
public class BusinessUserServiceImpl implements BusinessUserService{

    @Autowired
    BusinessUserDao businessUserDao;

    @Override
    public BusinessUser validUser(String userName,String password,String serviceId,String key){
        BusinessUser businessUser = businessUserDao.findOne(userName);
        if(CommonUtil.isNotEmpty(businessUser)){
            if(!businessUser.getPassword().equals(password)||!businessUser.getServiceId().equals(serviceId)||!businessUser.getKey().equals(key)){
                return null;
            }
        }
        return businessUser;
    }
    @Transactional(isolation=Isolation.READ_COMMITTED,readOnly=false,propagation=Propagation.REQUIRED,value="transactionManager")
    @Override
    public void editUser(String userName) {
        BusinessUser bu = new BusinessUser();
        bu.setUserName(userName);
        businessUserDao.edit(userName);
    }

    @Override
    public void deleteUser(String userName) {

    }   
}

web.xml

 <?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" metadata-complete="false" version="3.0">
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <listener>
    <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
  </listener>
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>
            classpath:spring/applicationContext-main.xml
        </param-value>
  </context-param>
  <context-param>
    <param-name>spring.profiles.active</param-name>
    <param-value>dev</param-value>
  </context-param>
  <filter>
    <filter-name>ParseRequestFilter</filter-name>
    <filter-class>com.feinno.elev.interfaces.filter.ParseRequestFilter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>ParseRequestFilter</filter-name>
    <url-pattern>/dispatcher</url-pattern>
  </filter-mapping>
  <filter>
    <filter-name>CharacterEncodingFilter</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>CharacterEncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  <servlet>
    <servlet-name>DispatcherServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:spring/applicationContext-mvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>DispatcherServlet</servlet-name>
    <url-pattern>/*</url-pattern>
  </servlet-mapping>
</web-app>

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

5条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
mfkykiytbb 2015-05-03 13:00
关注
沉了！！！！！能顶上去不？？？？

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

entityManager 如何执行自定义insert语句？数据库
2018-09-13 06:58

回答 3 已采纳 entityManager.createNativeQuery(updateSql).executeUpdate(); 在你的方法里调用这个原生态数据库持久化操作，如果方法里仅仅是这一句，你会发现报
PDO：连接为singleton =线程问题？ php
2013-01-27 20:07

回答 2 已采纳 Do not worry about using a singleton to establish the connection. Every php script request will h
Symfony 2中我的数据库中最后一次插入/更新/删除的时间 php symfony
2012-09-14 14:19

回答 1 已采纳 I bet you're using InnoDB, and InnoDB doesn't support UPDATE_TIME. Your best bet is to create an
加了事务控制@Transactional还是报错executing an update/delete query
2022-02-08 10:46

pizssn的博客昨天调试程序的时候发现，我的一个service在执行修改数据库的命令的时候报executing an update/delete query的错。一开始我也以为是没有加事务控制的原因，于是我在我的这个service上添加了@Transactional...
PHP MySQL信息更新不起作用 mysql php
2017-02-08 09:17

回答 1 已采纳 Thank You Everyone for spending time on my question. I could not have found the answer without hav
MySQL连接错误（使用golang）：连接过多，运行中的睡眠连接过多（超过8000个）show processlist mysql
2017-05-16 11:33

回答 1 已采纳 You have a defer inside of a loop, which just pushes the row.Close function onto the stack, and wi
带有空结果的AJAX请求 - 清除我们的HTML输入字段 ajax html javascript jquery php
2016-03-23 10:17

回答 2 已采纳 You just need to check if senderMobile has a value. Try this: if (data.error) { alert("error"
JPA事务问题Executing an update/delete query
2020-10-07 15:05

兔子先生9959的博客问题代码 ///删除操作 @RequestMapping("/delete") public String delete(){ Pmarea p = new Pmarea(); //p.setName("葫芦岛吴奇隆"); p.setId(10); textDao.delete(p); return "delete ok"; } 报出异常：...
Symfony2 - SQLSTATE [23000]：完整性约束违规：1062重复条目 - SonataAdminBundle - INSERT后更新 php sql symfony
2014-07-05 07:36

回答 2 已采纳 When I had update Symfony 2.3 to 2.6@dev in my composer.json, I solve my problem. For sure, it was
如何获得PHP回应的div内容 html javascript jquery php
2015-06-05 07:40

回答 7 已采纳 You shouldn't need to append the return data to the page at all. Why don't you run your function i
从图库中删除图像和复制 mysql php
2013-12-15 09:06

回答 3 已采纳 fix this in delete button html, to pass the file name by the url <h4 class="btn-green"><
javax.persistence.TransactionRequiredException: Executing an update/delete query
2019-06-11 14:58

言一木的博客最近在springboot中整合jpa的时候碰到一... javax.persistence.TransactionRequiredException: Executing an update/delete query at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(Abstrac...
jQuery AJAX请求只发送第一个表单，忽略其他表单 javascript jquery mysql php
2015-04-27 09:46

回答 3 已采纳 Well, the problem is how you are selecting them in jQuery and how you have\ named them in HTML. Y
Executing an update/delete query报错
2021-02-24 17:46

五爷_family的博客如果JPA提示Executing an update/delete query，那是一定是因为Service层没有加@Transactional和再方法加@Modifying吧。异常场景 spring-boot+jpa执行新增修改删除操作时： public interface UserRepository ...
解决问题：JPA报错：Executing an update/delete query
2018-09-18 11:34

Soulmate_Min的博客 spring boot jpa 报错 :Executing an update/delete query 如果JPA提示Executing an update/delete query，那是一定是因为没有加@Transactional和@Modifying。因为JPA没有事务支持，不能执行更新和删除操作。 ...
Executing an update/delete query； nested exception is javax.persistence.TransactionRequiredException
2022-07-18 18:57

ccccls的博客利用注解@Transaction解决Executing an update/delete query; nested exception is javax.persistence.TransactionRequiredException: Executing an update/delete query问题
JPA javax.persistence.TransactionRequiredException: Executing an update/delete query问题解决
2021-10-17 11:19

旭东怪的博客 javax.persistence.TransactionRequiredException: Executing an update/delete query 问题分析： 1、JPA使用Query.executeUpdate()方法对数据库进行更新时，没有添加@Transactional事务注解，导致insert、update...
【开发专题_02】Executing an update/delete query
2021-04-17 11:35

纸飞机-暖阳的博客【开发专题_02】Executing an update/delete query
jpa 自定义逻辑删除报错Executing an update/delete query
2023-07-21 14:55

飞流银河的博客 jpa 自定义逻辑删除报错Executing an update/delete query
SpringData JPA 提示:TransactionRequiredException: Executing an update/delete query
2020-12-02 19:32

在奋斗的大道的博客问题场景： package com.zzg.dao; import javax.transaction.Transactional; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository....
没有解决我的问题, 去提问

悬赏问题

¥15 关于#matlab#的问题：在模糊控制器中选出线路信息，在simulink中根据线路信息生成速度时间目标曲线（初速度为20m/s，15秒后减为0的速度时间图像）我想问线路信息是什么
¥15 banner广告展示设置多少时间不怎么会消耗用户价值
¥16 mybatis的代理对象无法通过@Autowired装填
¥15 可见光定位matlab仿真
¥15 arduino 四自由度机械臂
¥15 wordpress 产品图片 GIF 没法显示
¥15 求三国群英传pl国战时间的修改方法
¥15 matlab代码代写，需写出详细代码，代价私
¥15 ROS系统搭建请教（跨境电商用途）
¥15 AIC3204的示例代码有吗，想用AIC3204测量血氧，找不到相关的代码。

@Query 事务问题，Executing an update/delete query

5条回答 默认 最新

悬赏问题

5条回答默认最新