最近我根据上述的技术体系图搜集了几十套腾讯、头条、阿里、美团等公司21年的面试题,把技术点整理成了视频(实际上比预期多花了不少精力),包含知识脉络 + 诸多细节,由于篇幅有限,这里以图片的形式给大家展示一部分
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 );
如此,问题解决。
[
![](https://img-blog.csdnimg.cn/fce44ffe4f1f493b84f6e057060c9c93.png)
创作打卡挑战赛 ![](https://img-blog.csdnimg.cn/img_convert/81aad5edb5a937c22417fdffe7481e58.png)
赢取流量/现金/CSDN周边激励大奖
# 最后
学习视频:
![](https://img-blog.csdnimg.cn/img_convert/dbc0920b2e7eda8141033ca986f4f9e6.webp?x-oss-process=image/format,png)
大厂面试真题:
![](https://img-blog.csdnimg.cn/img_convert/a6a39d2182bd778dabf2a8955b607f74.webp?x-oss-process=image/format,png)
> **本文已被[CODING开源项目:【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)收录**
**[需要这份系统化的资料的朋友,可以点击这里获取](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)**
239053219)]
> **本文已被[CODING开源项目:【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)收录**
**[需要这份系统化的资料的朋友,可以点击这里获取](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)**