记录一次很坑的报错----jpa中@Query注解传参是对象时，报错org.springframework.dao.InvalidDataAccessApiUsageException:

最新推荐文章于 2022-02-22 10:14:01 发布

PiaoYoung

最新推荐文章于 2022-02-22 10:14:01 发布

阅读量1.8k

点赞数 2

分类专栏： spring boot Java 文章标签： java

本文链接：https://blog.csdn.net/qq_41814700/article/details/107347731

版权

本文记录了一次使用 JPA 的 @Query 注解时遇到的参数绑定错误，通过修改参数取值方式解决了问题。原代码中混合使用了 #{...} 和 :... 的参数绑定方式导致报错，修正后将所有参数统一为 #{...} 形式，成功解决了InvalidDataAccessApiUsageException。

摘要由CSDN通过智能技术生成


2020-07-14 21:21:23.423  INFO 17292 --- [erListUpdater-0] c.netflix.config.ChainedDynamicProperty  : Flipping property: YSS-BASE-BILLOWS.ribbon.ActiveConnectionsLimit to use NEXT property: niws.loadbalancer.availabilityFilteringRule.activeConnectionsLimit = 2147483647
2020-07-14 21:21:23.555 ERROR 17292 --- [           main] c.y.l.f.biz.InformationPublishFlowBiz    : No parameter binding found for name subprocessCallRel!; nested exception is java.lang.IllegalArgumentException: No parameter binding found for name subprocessCallRel!

org.springframework.dao.InvalidDataAccessApiUsageException: No parameter binding found for name subprocessCallRel!; nested exception is java.lang.IllegalArgumentException: No parameter binding found for name subprocessCallRel!
	at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:384) ~[spring-orm-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:246) ~[spring-orm-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:488) ~[spring-orm-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59) ~[spring-tx-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) ~[spring-tx-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147) ~[spring-tx-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133) ~[spring-data-jpa-1.11.6.RELEASE.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57) ~[spring-data-commons-1.13.6.RELEASE.jar:na]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
	at com.sun.proxy.$Proxy183.getOneByRel(Unknown Source) ~[na:na]
	at com.yss.lifecycle.flow.biz.InformationPublishFlowBiz.getOneByRel(InformationPublishFlowBiz.java:80) ~[classes/:na]
	at com.yss.lifecycle.flow.service.impl.InformationPublishFlowServiceImpl.generateUpcomingTask(InformationPublishFlowServiceImpl.java:756) [classes/:na]
	at com.yss.lifecycle.flow.service.impl.InformationPublishFlowServiceImpl$$FastClassBySpringCGLIB$$11057109.invoke(<generated>) [classes/:n