spring data jpa的一个异常

最新推荐文章于 2021-08-25 09:50:33 发布
最新推荐文章于 2021-08-25 09:50:33 发布
阅读量790 收藏
点赞数
分类专栏： spring-boot jpa 文章标签： jpa spring exception 异常
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yanlici1249075710/article/details/78489413
版权

org.springframework.dao.InvalidDataAccessApiUsageException: Parameter with that position [2] did not exist; nested exception is java.lang.IllegalArgumentException: Parameter with that position [2] did not exist
at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:384)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:227)
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:417)
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:131)atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)atorg.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)atcom.sun.proxy. Proxy105.updateTestParameter(Unknown Source)
at com.dianju.trustedSign.modules.org.controllers.AccountController.testUpdateOne(AccountController.java:520)
at com.dianju.trustedSign.modules.org.controllers.AccountController

FastClassBySpringCGLIB
767e81c3.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)atorg.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)atcom.dianju.trustedSign.core.modules.rbacOperation.OperationAspect.before(OperationAspect.java:56)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(UnknownSource)atsun.reflect.DelegatingMethodAccessorImpl.invoke(UnknownSource)atjava.lang.reflect.Method.invoke(UnknownSource)atorg.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)atorg.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)atorg.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)atorg.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)atorg.springframework.aop.framework.CglibAopProxy DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
at com.dianju.trustedSign.modules.org.controllers.AccountController
EnhancerBySpringCGLIB
acb2592e.testUpdateOne()
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.doInvoke(InvocableHandlerMethod.java:222)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:814)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:737)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:871)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
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.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
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.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:87)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
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.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
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:121)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
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:212)
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:141)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:521)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)
at org.apache.coyote.AbstractProtocol AbstractConnectionHandler.process(AbstractProtocol.java:674)atorg.apache.tomcat.util.net.NioEndpoint SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint SocketProcessor.run(NioEndpoint.java:1456)atjava.util.concurrent.ThreadPoolExecutor.runWorker(UnknownSource)atjava.util.concurrent.ThreadPoolExecutor Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread WrappingRunnable.run(TaskThread.java:61)atjava.lang.Thread.run(UnknownSource)Causedby:java.lang.IllegalArgumentException:Parameterwiththatposition[2]didnotexistatorg.hibernate.jpa.spi.BaseQueryImpl.findParameterRegistration(BaseQueryImpl.java:518)atorg.hibernate.jpa.spi.BaseQueryImpl.setParameter(BaseQueryImpl.java:674)atorg.hibernate.jpa.spi.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:198)atorg.hibernate.jpa.spi.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:49)atorg.springframework.data.jpa.repository.query.ParameterBinder.bind(ParameterBinder.java:152)atorg.springframework.data.jpa.repository.query.StringQueryParameterBinder.bind(StringQueryParameterBinder.java:61)atorg.springframework.data.jpa.repository.query.ParameterBinder.bind(ParameterBinder.java:111)atorg.springframework.data.jpa.repository.query.SpelExpressionStringQueryParameterBinder.bind(SpelExpressionStringQueryParameterBinder.java:69)atorg.springframework.data.jpa.repository.query.ParameterBinder.bindAndPrepare(ParameterBinder.java:172)atorg.springframework.data.jpa.repository.query.ParameterBinder.bindAndPrepare(ParameterBinder.java:163)atorg.springframework.data.jpa.repository.query.AbstractStringBasedJpaQuery.doCreateQuery(AbstractStringBasedJpaQuery.java:78)atorg.springframework.data.jpa.repository.query.AbstractJpaQuery.createQuery(AbstractJpaQuery.java:169)atorg.springframework.data.jpa.repository.query.JpaQueryExecution SingleEntityExecution.doExecute(JpaQueryExecution.java:206)
at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:78)
at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:100)
at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:91)
at org.springframework.data.repository.core.support.RepositoryFactorySupport QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:462)atorg.springframework.data.repository.core.support.RepositoryFactorySupport QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:440)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
… 79 more

其实上面的问题就是：该位置[ 2 ]的参数不存在

@Query("update TestParameter set dictCode =?1 where dictName =?1")
    public int updateTestParameter(String dictName,String dictCode);

正确代码应该是

@Query("update TestParameter set dictCode =?1 where dictName =?2")
    public int updateTestParameter(String dictName,String dictCode);
1249075710
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Spring Data JPA API（Spring Data JPA 开发文档）.CHM
08-31
Spring Data JPA API。 Spring Data JPA 开发文档。 官网 Spring Data JPA API。
【错误解决】Spring JPA的错误及其解决方案
小鼠标的博客
09-12 2万+
昨天测试Spring jpa遇到一个错误，，遇到错误“三板斧”【1】 看控制台报错情况，一般情况下红色第一句很重要，细看（英文很水没关系，打开有道瞬间转换成中文，虽然有点变扭，能看） 比如，我这个错误， org.springframework.dao.InvalidDataAccessApiUsageException: Parameter value [1] did not matc
InvalidDataAccessApiUsageException异常的三个处理方
热门推荐
xys_00
12-22 2万+
原因一： 这个异常产生的主要原因是DAO采用了Spring容器的事务管理策略，如果操作方法的名称和事务策略中指定的被管理的名称不能够匹配上，spring 就会采取默认的事务管理策略(PROPAGATION_REQUIRED,read only).如果是插入和修改操作，就不被允许的，所以包这个异常 原因二： 在网上搜了一下，其中大多数文章又是提OpenSessionInViewFilter又是
【JPA】JPA 多对多映射报错信息：detached entity passed to persist原因汇总
计忆芳华的博客
04-02 2085
org.springframework.dao.InvalidDataAccessApiUsageException: detached entity passed to persist: com.wxl.pojo.Tag; nested exception is org.hibernate.PersistentObjectException: detached entity passed to...
【hibernate】报错：org.springframework.dao.DataIntegrityViolationException: could not execute statement; ...
weixin_33834679的博客
04-03 1054
报错如下： org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement at o...
java jpa更新数据_spring-data-jpa更新数据InvalidDataAccessApiUsageException：Executing an update/delete query...
weixin_39849479的博客
02-27 295
@Modifying@Query("update Xxx set success=:success,costMs=:costMs,updateTimestamp=:updateTimestamp where traceId=:traceId")void updateXxx(@Param("traceId") String traceId, @Param("success") Boolean suc...
关于JPA框架使用@Query自定义SQL加入逻辑判断if函数失败处理方案
weixin_41024965的博客
08-25 2322
由于业务比较复杂，已经在service 增加很多逻辑判断，后思考如何简化代码，考虑在@Query中增加逻辑判断，查找网上很多资料，都是在SQL中增加if函数，但是都显示报错 类似这种都是sql报错，最后使用case when 作为逻辑判断 错误解决 ...
Database--No EntityManager with actual transaction available for current thread...
悄悄接
11-30 527
在使用SpringDataJpa数据库操作
Parameter with that position [1] did not exist已解决
weixin_41959701的博客
04-18 4552
报错信息：[ERROR] org.apache.juli.logging.DirectJDKLog.log(DirectJDKLog.java:182) : Servlet.service() for servlet [dispatcherServlet] in context with path [/springbootdemo] threw exception [Request process...
Spring Data JPA中文文档[1.4.3]_springdatajpa_erlang_waitxpf_
10-02
Spring Data JPA中文文档1.4.3
Spring Data JPA的优点和难点.pdf
12-05
3. 与Spring全家桶结合紧密： 4. 成熟的框架和架构 常⻅的SQL性能问题，如何优雅处理? 2. 错综复杂的关联关系如何应对？ 3. 万恶的LazyException本质是什么？ 4. ⾼并发⾼性能要求的API服务要⽤JPA吗？
Spring Data Jpa实现自定义repository转DTO
08-18
主要介绍了Spring Data Jpa实现自定义repository转DTO,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下
json异常之JsonMappingException
yanlici1249075710的博客
11-15 1万+
2017-11-15 16:43:06[com.dianju.trustedSign.core.modules.models.SystemOutPrint]-[INFO] org.springframework.http.converter.HttpMessageNotReadableException: Could not read document: Can not deserialize in
java.lang.IllegalStateException: javax.websocket.server.ServerContainer not available
yanlici1249075710的博客
05-28 7699
"C:\Program Files\Java\jdk1.8.0_251\bin\java.exe" -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2019.2.3\lib\idea_rt.jar=53883:C:\Program Files\JetBrains\IntelliJ IDEA 2019.2.3\bin" -Dfile.encoding=UTF-8 -.
springboot开发中使用postman 向后台传递json数据的时候，为空
yanlici1249075710的博客
11-09 6907
我的错误原因就是因为，在spring注解开发中，使用get或者是post请求的时候，就是需要这些注意事项 这里写图片描述 就是这两个地方搞混，后台就会拿不到前台传递的json数据
springboot项目启动报警java.sql.SQLException:
yanlici1249075710的博客
11-14 2438
springboot springdata jpa
java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String
yanlici1249075710的博客
06-05 1697
"C:\Program Files\Java\jdk1.8.0_251\bin\java.exe" -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-j.
springboot + jpa 启动报警之SQL异常
yanlici1249075710的博客
11-15 1474
2017-11-15 18:48:27[org.hibernate.hql.internal.ast.ErrorCounter]-[ERROR] line 1:70: unexpected token: or 2017-11-15 18:48:27[org.hibernate.hql.internal.ast.ErrorCounter]-[ERROR] line 1:70: unexpected
Spring Data JPA
最新发布
07-09
Spring Data JPA 是 Spring 框架中的一个模块，它提供了一种方便的方式来访问和操作数据库，同时也简化了开发人员的工作。它基于 JPA 规范，提供了一些常用的 CRUD 操作方法，同时也支持自定义查询和分页查询等功能...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值