org.springframework.dao.InvalidDataAccessResourceUsageException: Not all named parameters have been

最新推荐文章于 2022-05-20 01:57:18 发布
最新推荐文章于 2022-05-20 01:57:18 发布
阅读量726 收藏
点赞数
分类专栏： exception 文章标签： ireport sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sunfly01/article/details/109079022
版权

at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:264)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:218)
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)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at com.sun.proxy.Proxy86.countBySQL(Unknown Source)
at org.platform.service.report.service.impl.TemplateReportServiceImpl.getData(TemplateReportServiceImpl.java:33)
at org.platform.service.report.controller.jasperReport.ReportIndexController.findDataCount(ReportIndexController.java:158)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
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.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:112)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
at org.apache.shiro.web.servlet.AbstractShiroFilter1.call(AbstractShiroFilter.java:365)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.platform.service.common.filter.ParamTrimFilter.doFilter(ParamTrimFilter.java:23)
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)
at org.apache.tomcat.util.net.NioEndpoint SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint SocketProcessor.run(NioEndpoint.java:1456)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.QueryException: Not all named parameters have been set: ["]

使用ireport制作报表，日志打印报错如上。找了一天的原因呢，终于在下班前搞明白了。
是因为sql有问题，我还以为是配置时哪里配错了，反复查看了N多次。
注意两点：1.看看sql查询的字段别名是否有些没有引号引起来；2.看看是不是有些地方用了双引号，全改成单引号！！！

sunfly01
关注
专栏目录
SpringBoot,测试插入数据时报:org.springframework.dao.InvalidDataAccessResourceUsageException: error performin
qq_45473292的博客
04-30 402
完整错误： org.springframework.dao.InvalidDataAccessResourceUsageException: error performing isolated work; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: error performing isol...
org.springframework.dao.ConcurrencyFailureException: StatementCallback 问题排查
程序员野蛮成长
08-14 2858
  该问题多为数据库发生了死锁导致的 异常 说明 CleanupFailureDataAccessException DAO操作失败执行，但在数据库资源释放时发生异常，如关闭Connection时发生异常等 ConcurrencyFailureException 表示在进行并发数据库操作时发生异常，如乐观锁无法获取、悲观锁无法获取、死锁引发发失败等。 DataAc...
关于SpringBoot中jpa org.springframework.dao.InvalidDataAccessResourceUsageException: 解决办法
yilihuang的博客
06-08 1万+
错误信息：org.springframework.dao.InvalidDataAccessResourceUsageException: error performing isolated work; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: error performing isola...
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exc...
weixin_34355881的博客
09-02 1058
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute queryat org.springframewor...
springboot报错org.springframework.dao.InvalidDataAccessResourceUsageException:
weixin_45537241的博客
08-18 1万+
org.springframework.dao.InvalidDataAccessResourceUsageException: error performing isolated work; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: error performing isolated w...
org.springframework.dao.InvalidDataAccessResourceUsageException
m0_37626203的博客
10-19 4195
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement  
org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update
05-11
这个异常通常出现在使用 JDBC 执行批量更新操作时出现问题。可能的原因包括 SQL 语法错误，数据库连接问题，表结构不匹配等。你可以尝试以下方法解决该异常： 1. 检查 SQL 语句是否正确，特别是语法是否正确。...
org.springframework.dao.invaliddataaccessresourceusageexception: could not extract resultset; sql [n/a]; nested exception is org.hibernate.exception.sqlgrammarexception: could not extract resultset
03-16
这个错误消息表明在使用Spring Data Access时出现了无效的资源使用异常，并且无法提取结果集，这可能是由于SQL语法错误导致的Hibernate异常。建议检查SQL语句是否正确，以及与数据库的连接是否正常。
org.springframework.dao.invaliddataaccessresourceusageexception
最新发布
06-06
org.springframework.dao.InvalidDataAccessResourceUsageException是Spring框架中的一个异常类，表示数据访问资源使用不当的异常。通常出现在数据访问层的代码中，可能是SQL语句错误、数据库连接问题等引起的异常。...
Not all named parameters have been set
iteye_10306的博客
03-08 5849
1、从页面上获取的是字符创类型的日期 如：date = "2012-3-14"如下是SQL: 2、SQL select t.a,t.b,count(*) from 表名 t where t.add_date >= to_timestamp(date 00:00:00.000000,'yyyy-mm-dd hh24:mi:ss.ff') and t.add_date = to...
org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet
Wang176868的博客
07-20 2959
这里写自定义目录标题解决办法新的改变功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 org.springframework.dao.InvalidDataAccessResourceUsageException: could no
报错org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet； SQL
weixin_47192515的博客
05-20 7703
org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet 问题原因： 这个错误是由无法找到数据库与实体类对应的字段导致异常的： 在控制台看见：突然想起mysql好像是不区分大
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query;
热门推荐
zhqingyun163的专栏
01-13 4万+
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query;   sql 语句错误举例：   错误方法：@SuppressWarnings("unchecked") public List findMemberByName(String name) { L
Hibernate QueryException:Not all named parameters have been set:
hello,today!
09-28 1万+
现象: 不带条件查询时,可以查询到数据 带条件查询时,报错 出错位置 是在执行Query对象的list()方法时,导致错误的原因是前面设置参数的时候有问题 条件 少了一个 ! 号     导致不带条件查询时,判断为false,可以正常查询,带条件时,条件判断仍为false,参数设置失败 正确是if(paramMap != nul
org.springframework.dao.InvalidDataAccessResourceUsageException: Unexpected cursor position change. ...
weixin_30273175的博客
09-29 462
在用SpringBatch 跑job的时候出现这个错误， 由于取数据的DB 是netezza， 框架可能支持的不是很全面，当然也可能是其他原因。 <bean id="reader_rdc" class="org.springframework.batch.item.database.JdbcCursorItemReader" scope="step"...
Not all named parameters have been set: [mi:ss, 56:05, 56:01] [select a.
Aeyewp的博客
04-12 3034
Not all named parameters have been set: [mi:ss, 56:05, 56:01] [select a.zxbs 这时出现在dao层拼接sql语句的时候的错误！而这些错误肯定是在拼接sql语句的时候有问题。只需要在后台将我们拼好的sql语句放到数据库中进行查询就能找到问题，一般是格式问题或者后台处理前台数据出现了问题。
遇到的Not all named parameters have been set: [3, 5, 4]
hongtaq的专栏
08-04 1万+
org.hibernate.QueryException: Not all named parameters have been set: [3, 5, 4] [select o from ProductInfo o  where o.visible=?1 and  o.type.typeid in(?2,?3,?4,?5) order by o.createDate desc]   上次写错
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值