at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)
at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
Caused by: org.hibernate.QueryException: Ordinal parameter not bound : 10
at org.hibernate.query.internal.QueryParameterBindingsImpl.verifyParametersBound(QueryParameterBindingsImpl.java:213)
at org.hibernate.query.internal.AbstractProducedQuery.beforeQuery(AbstractProducedQuery.java:1403)
at org.hibernate.query.internal.NativeQueryImpl.beforeQuery(NativeQueryImpl.java:246)
at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1582)
at org.springframework.data.jpa.repository.query.JpaQueryExecution$ModifyingExecution.doExecute(JpaQueryExecution.java:263)
at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:91)
at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:136)
at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:125)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:605)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.lambda$invoke$3(RepositoryFactorySupport.java:595)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:595)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
... 45 more
[]( )二、解决
-------------------------------------------------------------------
首先看下我的代码
xxxRepository
@Modifying
@Transactional
@Query(value = "UPDATE "+
"xxx.dbo.xxxx"+
"SET "+
"xxx1= :#{#aaa.a}, "+
"xxx2= :#{#aaa.b}, "+
"xxx3= :#{#aaa.n}, "+
"xxx4= :#{#aaa.f}, "+
"xxx5= :#{#aaa.g}, "+
"xxx6= :#{#aaa.h}, "+
"xxx7= :#{#aaa.j}, "+
"xxx8= getdate(), "+
"xxx9=?2 "+
"WHERE "+
"xxxId=(SELECT xxxId FROM xxx.dbo.bbbb WHERE TermSheetId = ?3 )", nativeQuery = true)
void saveXXXX(@Param(“aaa”) XXXX aaa, String userId, int termSheetId);
最开始怀疑是
①参数顺序的错,可是不管?2和?3怎么换(换成?1和?2)还是报错。
②加上@Param参数绑定也依然出错。
③以为是空格引起的错误,可是各种参数?2和?3附近都试过加空格去空格也都没用
接下来,敲黑板,重点来了。
我们需要把需要?1 ?2绑定的放在前面,之后序号从?1开始计算,把使用@Param的放到最后,总之就是在SQL使用?1这种序号绑定的要放在参数前面。
比如把
void saveXXXX(@Param("aaa") XXXX aaa, String userId, int termSheetId);
换成
void saveXXXX(String userId, int termSheetId, @Param("aaa") XXXX aaa);
之后序号从?1,?2开始绑定
修改后的代码
@Modifying
@Transactional
@Query(value = "UPDATE "+
"xxx.dbo.xxxx"+
"SET "+
"xxx1= :#{#aaa.a}, "+
"xxx2= :#{#aaa.b}, "+
"xxx3= :#{#aaa.n}, "+
"xxx4= :#{#aaa.f}, "+
"xxx5= :#{#aaa.g}, "+
"xxx6= :#{#aaa.h}, "+
"xxx7= :#{#aaa.j}, "+
"xxx8= getdate(), "+
"xxx9=?1 "+
"WHERE "+
"xxxId=(SELECT xxxId FROM xxx.dbo.bbbb WHERE TermSheetId = ?2 )", nativeQuery = true)
void saveXXXX(String userId, int termSheetId, @Param("aaa") XXXX aaa );
如此,问题解决。
# 最后
现在其实从大厂招聘需求可见,在招聘要求上有高并发经验优先,包括很多朋友之前都是做传统行业或者外包项目,一直在小公司,技术搞的比较简单,没有怎么搞过分布式系统,但是现在互联网公司一般都是做分布式系统。
所以说,如果你想进大厂,想脱离传统行业,这些技术知识都是你必备的,下面自己手打了一份Java并发体系思维导图,希望对你有所帮助。
![](https://img-blog.csdnimg.cn/img_convert/aa81fe39f0ecd7075bc37883bff5db67.webp?x-oss-process=image/format,png)
现在其实从大厂招聘需求可见,在招聘要求上有高并发经验优先,包括很多朋友之前都是做传统行业或者外包项目,一直在小公司,技术搞的比较简单,没有怎么搞过分布式系统,但是现在互联网公司一般都是做分布式系统。
所以说,如果你想进大厂,想脱离传统行业,这些技术知识都是你必备的,下面自己手打了一份Java并发体系思维导图,希望对你有所帮助。
[外链图片转存中...(img-KBhuKJw1-1714584246402)]
> **本文已被[CODING开源项目:【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】](https://bbs.csdn.net/topics/618154847)收录**