@Query nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet

最新推荐文章于 2024-08-22 16:56:00 发布
最新推荐文章于 2024-08-22 16:56:00 发布
阅读量1.9k 收藏
点赞数
分类专栏： # SpringBoot Bug # Spring Data JPA 文章标签： hibernate java spring boot
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kicinio/article/details/111826837
版权

异常：

org.hibernate.exception.JDBCConnectionException: could not extract ResultSet
    org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:132)
    org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
    org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
    org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
    org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:89)
    org.hibernate.loader.Loader.getResultSet(Loader.java:2065)
    org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)
    org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
    org.hibernate.loader.Loader.doQuery(Loader.java:909)
    org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
    org.hibernate.loader.Loader.doList(Loader.java:2553)
    org.hibernate.loader.Loader.doList(Loader.java:2539)
    org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369)
    org.hibernate.loader.Loader.list(Loader.java:2364)
    org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:496)
    org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
    org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:231)
    org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264)
    org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
    com.dave.gamebeta.dao.GameDAO.getRanking(GameDAO.java:83)
    com.dave.gamebeta.action.GameAction.getRanking(GameAction.java:84)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:483)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
    org.apache.struts2.interceptor.DeprecationInterceptor.intercept(DeprecationInterceptor.java:41)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
    org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:249)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:249)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:139)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:562)
    org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:434)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
    org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
    org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    java.lang.Thread.run(Thread.java:744)

解决方法：

在repomsitory层中的@Query注解上面增添如下两个注解：

@Modifying 

@Transactional

说明：针对于普通的select类型的语句，是不需要增加这样个注解（单独查询没有事物性而言），但当我们操作了例如update或delete，insert类型的语句，就存在了事务性，所以必须要增添上面两个注解。

kicinio
关注
专栏目录
WebService客户端调用总是出错
ZHANGLIXIA790123654的专栏
04-03 1682
我的客户端用cxf发布，客户端原先用CXF调用webservice，但是还是出问题，最后根据一个博客的指导，我换了axis来调用，但是还是出现各种问题，现在除了如下问题： type Exception report message The given SOAPAction http://server.webservice.struts2.com/LogWebService/IsCorrec
【知识整理】nested exceptionis org.hibernate.exception.GenericJDBCException: Cannot open connection。
热门推荐
qq_19891827的博客
07-05 4万+
一。本人将公司基于SSH(Spring,SpringMVC,Hibernate)的web项目上传至远程服务器，打开网页后报500错误。查看日志文件，发现后台抛出了如下异常：nested exceptionis org.hibernate.exception.GenericJDBCException: Cannot open connection。翻译过来大意是说，在使用Hibernate通过JDB
could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could
MrZhang的博客
03-20 9252
1报错： could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet // 标记资源的statu为 -999 basResourceRepo.updateStatusByResId(recId); 就一个upda...
成功解决：could not extract ResultSet
最新发布
日常笔记 | 干货分享 | 毕设源码 | 毕设指导 | 答辩指导
08-22 1032
这个错误信息表示在执行数据库查询时，Hibernate遇到了一个，具体原因是无法从数据库中提取ResultSet，这通常指的是在查询执行后无法正确获取结果集。是处理 SQL 异常的一个类或方法，Line:63 表示错误发生在代码中的第 63 行。错误通常与数据库查询的执行或结果提取有关。解决问题的关键是查看SQL语句、数据库连接、数据类型匹配以及Hibernate和JDBC的配置。通过分析详细的日志和异常堆栈，可以更准确地找到问题根源并进行修复。
jpa语句：nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet
小码农吗
07-27 1万+
一、问题 一大早来公司看到日志中显示：nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet 赶紧去排查问题，。 竟发现是一条sql存在的问题 来看下代码咯 二、分析 从上面报错信息所看到是sql语句执行时候问题 于是乎想到了两个注解 @Modifying 和 @Transactional 先看下官方文档针对这个注解的解释 As the querie
Hibernate异常
weixin_43659674的博客
06-05 300
org.hibernate.exception.GenericJDBCException: could not extract ResultSet com.mysql.jdbc.PacketTooBigException: Packet for query is too large (3805 > 1024). You can change this value on the ...
could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet
09-07
而"nested exception is org.hibernate.exception.GenericJDBCException"则表示该异常是由Hibernate框架抛出的。 可能的原因包括： 1. 数据库连接问题：请确保数据库服务已启动，并且连接参数正确。 2. SQL语句错误...
nested exception is org.hibernate.boot.archive.spi.ArchiveException: Could not build ClassFile 问题解决
hzs33的博客
05-07 3040
springboot启动报错： Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2020-05-07 09:33:30 [ERROR] org.springframework.boot.SpringApplicati...
【SSH】nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
凤凰涅槃
03-18 2823
在进行SSH项目时，当添加一条用户信息时，蹦出来的错误。 报错分析 1.检查mysql是否开启，开启没有问题 2.检查你的 jdbc.properties 中的每一项是否正确 修改前的jdbc.properties jdbc.driver = com.mysql.jdbc.Driver jdbc.url = jdbc:mysql:///shop jdbc.user = root jd...
异常排查 PersistenceException：org.hibernate.exception.GenericJDBCException: could not execute statement
猴戏浅滩的博客
05-28 5510
具体异常信息如下： Unhandled exception: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692) at org.hib.
nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
qq_41970342的博客
07-25 1831
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connec...
could not extract ResultSet；nested exception is org.hibernate.exception.GenericJDBCException: could
LinggoLing的博客
12-21 2826
could not extract ResultSet
HTTP500nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement
qq_33873421的博客
06-12 753
HTTP Status 500 - Request processing failed; nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement
关于nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement问题
qq_40015179的博客
09-21 6565
最近在开发项目中出现过两次这样的错误： nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement org.postgresql.util.PSQLException: ERROR: cannot delete from table 表 because it does not have a replica identity and publishes deletes 第一次是
could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException...
一名假人的博客
02-25 1万+
Mysql问题 问题描述 当后端使用的是SpringJPA作为持久层的结局方案时，前端做新增请求时报错could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement 问题解决 解决方式 到mysql给相...
code is 9998;desc is 插入失败exception is org.hibernate.exception.JDBCConnectionException: Could not op
游海东的技术专栏
05-05 3554
1、错误描述 [ERROR:]2015-05-05 09:27:12,090 [插入失败] org.hibernate.exception.JDBCConnectionException: Could not open connection at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLSt
JPA报错could not execute statement； nested exception is org.hibernate.exception.GenericJDBCException:
huan1213858的博客
02-24 2007
jpa
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值