org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations

最新推荐文章于 2021-05-02 12:39:09 发布
最新推荐文章于 2021-05-02 12:39:09 发布
阅读量7.8k 收藏 2
点赞数 2
分类专栏： 问题分析 文章标签： HQL DML hibernate sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hh12211221/article/details/53817686
版权

今天在写数据接口的时候，涉及到数据库操作，在使用Spring Data更新数据时，意外的出现了如下错误：

源代码

     @Query("update WarningMonitor w set w.status = ?2 where w.id = ?1")
     int updateStatusByWarningMonitorId(Long id, int status);

错误信息

org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [update cn.mdsd.portal.domain.WarningMonitor w set w.status = ?2 where w.id = ?1]
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.errorIfDML(QueryTranslatorImpl.java:318)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:369)
	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:229)
	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1260)
	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
	at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
	at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495)
	at org.springframework.data.jpa.repository.query.JpaQueryExecution$SingleEntityExecution.doExecute(JpaQueryExecution.java:168)
	at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:59)
	at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:97)
	at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:88)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:384)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:344)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodIntercceptor.invoke(CrudMethodMetadataPostProcessor.java:111)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy1312.updateStatusByWarningMonitorId(Unknown Source)
	at cn.mdsd.portal.service.impl.WarningMonitorManagerImpl.updateStatusByWarningMonitorId(WarningMonitorManagerImpl.java:37)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy1313.updateStatusByWarningMonitorId(Unknown Source)
	at cn.mdsd.portal.web.spring.controller.WarningMonitorController.updateStatus(WarningMonitorController.java:187)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:685)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:844)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:436)
	at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:177)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:617)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1527)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1484)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)

问题分析

          从错误信息中，可以发现，@Query无法进行DML操作。

问题解决


     @Modifying
     @Query("update WarningMonitor w set w.status = ?2 where w.id = ?1")
     int updateStatusByWarningMonitorId(Long id, int status);

经上述改正，再次运行程序不在出现该错误！

wisdom_bo
关注
专栏目录
Sptring Data JPA的jqpl更新操作异常：QueryExecutionRequestException: Not supported for DML operations
狗凡的博客
10-09 375
测试类代码： /* 更新操作 */ @Test public void updateCustomer(){ customerDao.updateCustomer("西班牙",23l); } dao接口代码： //更新操作 @Query("update Customer set custSource=? wh...
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: Student is not mapped
游海东的技术专栏
02-23 1846
1、错误描述org.hibernate.hql.internal.ast.QuerySyntaxException: Student is not mapped [from Student ] at org.hibernate.hql.internal.ast.QuerySyntaxException.generateQueryException(QuerySyntaxException.jav
Spring Data之@Query中的org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML...
程序员光剑
04-13 8778
Spring Data之@Query中的org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML 1.问题描述 org.hibernate.hql.internal.QueryExecutionRequestException: Not support...
jpa 解决org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations
程序圆的博客
04-20 1078
异常堆栈信息 通过springdata jpa jpql编写 DAO接口update语句 要添加@Modifying注解 org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DM...
Spring Data之@Query中的org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML
木小鱼的笔记
03-04 1万+
Spring Data之@Query中的org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML错误信息。
springdata中internal.QueryExecutionRequestException: Not supported for DML operations
v790873的博客
11-24 592
报错： org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [delete from cn.lzh.springdata.pojo.Studen...
多表查询时No data type for node:org.hibernate.hql.ast.tree.IdentNode异常
Dxy的博客
05-11 1万+
使用SSH进行查询学生选课成绩时遇到的小问题，作一下记录，萌新程序员一个，多多指教需求：查询某个学生的选课成绩首先给出该案例使用到的三张数据表（使用的是MySql数据库）student学生表，course课程表，sc选课表具体如下图所示：学生表：（数据瞎写的，凑合看吧）学号、姓名、性别。。。主要使用sno课程表：课程号、学分、课程名选课表：学号、课程号、分数最开始考虑到SQL语句的编写需要学生、课...
Exception in thread "main" org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token:
VipMao的博客
05-18 6126
Exception in thread "main" org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: p near line 1, column 45 [select distinct p from com.mao.Person pjoin p.myEvent
weblogic12 下 org.hibernate.hql.ast.HqlToken
04-20
### WebLogic 12下org.hibernate.hql.ast.HqlToken冲突解决方案 在使用WebLogic 12部署应用程序时，可能会遇到与`org.hibernate.hql.ast.HqlToken`相关的异常问题。这种异常通常与Hibernate版本之间的不兼容性有关...
【JavaWeb】 Not supported for DML operations
哈哈哈哈哈哈哈
02-08 3390
在UPDATE时报错。 解决：添加@Modifying注解。 百度到的总结： （1）可以通过自定义的 JPQL 完成 UPDATE 和 DELETE 操作。 注意： JPQL 不支持使用 INSERT； （2）在 @Query 注解中编写 JPQL 语句， 但必须使用 @Modifying 进行修饰. 以通知 　　SpringData， 这是一个 UPDATE 或 DELETE 操作...
异常:Not supported for DML operations和异常Executing an update/delete query问题的解决
qq_16977687的博客
05-26 1980
在JPA的代码中，如果使用自定义update、delete语句时，例如： @Query(value = "delete from ManagerHistoryData c where c.tranDate = ?1") void deleteBalanceByDate(LocalDate tranDate); 会碰到”Not supported for DML operations [delete …的问题 解决办法 加上@Modifying注解 @Modifying @Query(value = "d
Spring+Data+JPA持久层的使用及注意事项(五)——Not supported for DML operations修改支持问题
laomadawei的博客
06-13 1792
org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [update cn.itcast.bos.domain.base.Standard set n...
Spring Data Jpa出现Not supported for DML operations
北辰
11-12 673
问题描述：在使用Spring Data Jpa的注解形式去配置删除sql语句，出现了下述异常： org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations Spring Data Jpa的注解形式去配置删除sql语句如下： ​@Query("delete fr
Spring data jpa 自定义SQL语句遇到错误Not supported for DML operations
蚁人的博客
08-08 2582
今天在自定义一个Update语句时运行遇到一个错误，显示Not supported for DML operations 也就是说不支持DML操作。我的UserRepository是继承的PagingAndSortingRepository接口，在看了JPA的文档之后，发现此接口不支持update事务，所以需要在注解上添加@Modifying。 以下是我的源码： @Modifying @Qu
JPA , Not supported for DML operations
41981DC的博客
01-06 767
在使用 JPA 的 @Query 自定义持久层方法时，运行报错： 错误日志： Not supported for DML operations 解决办法： 在方法上增加 @Modifying 注解。 @Modifying @Query(value = "UPDATE qtapd_project SET project_status = :status WHERE project_id...
解决Not supported for DML operations问题
dearbaba_11的博客
05-02 880
解决Not supported for DML operations问题
学习Spring JPA时报的Not supported for DML operations 错误
热门推荐
最美的路百转千回
06-03 2万+
在运行JPA修改数据代码报 Not supported for DML operations 错误 @Query(value = "update User user set user.address = :address where user.id = :id ") void findByUpdateUser(@Param("id") int id,@Param("address
org.hibernate.hql.ast.QuerySyntaxException is not mapped
最新发布
03-12
org.hibernate.hql.ast.QuerySyntaxException是Hibernate框架中的一个异常类，表示HQL查询语法错误或实体类未映射的异常。 当在Hibernate中执行HQL查询时，如果查询语法错误或者查询的实体类未正确映射到数据库表，就会抛出org.hibernate.hql.ast.QuerySyntaxException异常。 这个异常通常有以下几种可能的原因： 1. HQL查询语法错误：可能是查询语句中的表名、列名、关键字等写错了，或者查询条件不符合HQL语法规范。 2. 实体类未正确映射：可能是实体类的注解或配置文件中未正确配置映射关系，导致Hibernate无法找到对应的数据库表。 解决这个异常的方法包括： 1. 检查HQL查询语句是否正确，确保语法没有错误。 2. 检查实体类的注解或配置文件，确保实体类与数据库表的映射关系正确。 3. 检查数据库连接是否正常，确保Hibernate能够连接到数据库。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值