Connection reset和could not extract ResultSet

最新推荐文章于 2022-10-28 22:17:16 发布
最新推荐文章于 2022-10-28 22:17:16 发布
阅读量2.8k 收藏
点赞数
分类专栏： database Oracle java 文章标签： oracle连接池
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_30938705/article/details/110926947
版权
java 同时被 3 个专栏收录
56 篇文章 1 订阅
订阅专栏
Oracle
4 篇文章 0 订阅
订阅专栏
database
3 篇文章 0 订阅
订阅专栏

使用一段时间的项目突然报以下错误

[ERROR] [2020-12-09 03:45:20,296] [--JobRunnerPool-thread-41--] [com.alibaba.druid.pool.DruidDataSource]:1437 discard connection 
java.sql.SQLRecoverableException: IO Error: Connection reset
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1067)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1207)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery$original$aZhP6ViW(OraclePreparedStatement.java:3657)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery$original$aZhP6ViW$accessor$u7MbVmJ2(OraclePreparedStatement.java)
	at oracle.jdbc.driver.OraclePreparedStatement$auxiliary$D1aBoO5d.call(Unknown Source)
	at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
	at oracle.jdbc.driver.T4CPreparedStatement.executeQuery$accessor$gjmsQwZf(T4CPreparedStatement.java)
	at oracle.jdbc.driver.T4CPreparedStatement$auxiliary$0pPTGxfH.call(Unknown Source)
	at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)
	at oracle.jdbc.driver.T4CPreparedStatement.executeQuery(T4CPreparedStatement.java)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery$original$IyDc9F8b(OraclePreparedStatementWrapper.java:1495)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery$original$IyDc9F8b$accessor$8syzjGsT(OraclePreparedStatementWrapper.java)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper$auxiliary$T9qTA2Um.call(Unknown Source)
	at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:228)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
	at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:434)
	at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:186)
	at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
	at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86)
	at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:167)
	at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4004)
	at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:508)
	at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:478)
	at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:219)
	at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:278)
	at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:121)
	at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:89)
	at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1218)
	at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1101)
	at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:639)
	at org.hibernate.type.EntityType.resolve(EntityType.java:431)
	at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:151)
	at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:125)
	at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1146)
	at org.hibernate.loader.Loader.processResultSet(Loader.java:1005)
	at org.hibernate.loader.Loader.doQuery(Loader.java:943)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
	at org.hibernate.loader.Loader.doList(Loader.java:2615)
	at org.hibernate.loader.Loader.doList(Loader.java:2598)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2430)
	at org.hibernate.loader.Loader.list(Loader.java:2425)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1458)
	at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1426)
	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1398)
	at org.hibernate.Query.getResultList(Query.java:417)
	at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:72)
	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:467)
	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:74)
	at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:504)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:489)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133)
	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.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy193.findAll(Unknown Source)
	at com.eastcom.cams.service.BaseServiceImpl.findList(BaseServiceImpl.java:60)
	at com.eastcom.cams.service.BaseServiceImpl.findList(BaseServiceImpl.java:29)
	at sun.reflect.GeneratedMethodAccessor253.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy194.findList(Unknown Source)
	at com.eastcom.cams.executor.router.ScriptCatalogManager.getCatalogList(ScriptCatalogManager.java:49)
	at com.eastcom.cams.executor.router.ScriptCatalogManager.getList(ScriptCatalogManager.java:147)
	at com.eastcom.cams.executor.router.CatalogDispatcher.getList(CatalogDispatcher.java:79)
	at com.eastcom.cams.executor.processor.utils.CatalogUtils.getCatalogTree(CatalogUtils.java:38)
	at com.eastcom.cams.executor.processor.utils.CatalogUtils.getCaselogTree(CatalogUtils.java:93)
	at com.eastcom.cams.executor.processor.utils.CatalogUtils.getCaselogTree(CatalogUtils.java:102)
	at com.eastcom.cams.executor.processor.utils.CatalogUtils.getCaselogTree(CatalogUtils.java:102)
	at com.eastcom.cams.executor.processor.utils.CatalogUtils.getCatalogTree(CatalogUtils.java:48)
	at com.eastcom.cams.executor.processor.AbstractProcessor.getCatalogTree(AbstractProcessor.java:62)
	at com.eastcom.cams.executor.processor.param.AbstractParamProcessor.initDeviceCaseCmd(AbstractParamProcessor.java:204)
	at com.eastcom.cams.executor.processor.param.AbstractParamProcessor.init(AbstractParamProcessor.java:130)
	at com.eastcom.cams.executor.processor.param.AbstractParamProcessor.processTask(AbstractParamProcessor.java:168)
	at com.eastcom.cams.executor.JobRunnerImpl.run(JobRunnerImpl.java:34)
	at com.eastcom.dxframe.executor.runner.JobRunnerDelegate.run(JobRunnerDelegate.java:77)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.SocketException: Connection reset
	at java.net.SocketInputStream.read(SocketInputStream.java:209)
	at java.net.SocketInputStream.read(SocketInputStream.java:141)
	at oracle.net.ns.Packet.receive(Packet.java:308)
	at oracle.net.ns.DataPacket.receive(DataPacket.java:106)
	at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:324)
	at oracle.net.ns.NetInputStream.read(NetInputStream.java:268)
	at oracle.net.ns.NetInputStream.read(NetInputStream.java:190)
	at oracle.net.ns.NetInputStream.read(NetInputStream.java:107)
	at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)
	at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)
	at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
	... 109 common frames omitted
[WARN ] [2020-12-09 03:45:20,297] [--JobRunnerPool-thread-41--] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper]:129 SQL Error: 17002, SQLState: 08006 
[ERROR] [2020-12-09 03:45:20,298] [--JobRunnerPool-thread-41--] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper]:131 IO Error: Connection reset

异常抛出 discard connection java.sql.SQLRecoverableException: IO Error: Connection reset   大概意思是数据库IO错误，连接重置

查询资料得知：

当数据库连接池中的连接被创建而长时间不使用的情况下，该连接会自动回收并失效，但客户端并不知道，在进行数据库操作时仍然使用的是无效的数据库连接，这样，就导致客户端程序报“java.sql.SQLRecoverableException: IO Error: Connection reset” 或“java.sql.SQLRecoverableException 关闭的连接”异常。

有网友给出的避免出现这种情况的方法是

在配置数据源后面加上

<property name="validationQuery" value="select * from dual"/>


配置后，客户端在使用一个无效的连接时会先对该连接进行测试，如果发现该连接已经无效，则重新从连接池获取有效数据库连接来使用。

具体操作参考网友博客 解决Caused by: java.sql.SQLRecoverableException: IO Error: Connection reset相关问题

还有网友建议使用启动时加入以下参数

-Djava.security.egd=file:/dev/../dev/urandom

具体操作参考网友博客 JDBC访问Oracle数据库时遇到Connection Reset问题的分析

最简单的应该是扩大数据库连接池的最大、最小、空闲连接数等

 

还有一个异常

[ERROR] [2020-12-09 03:45:34,083] [--JobRunnerPool-thread-61--] [xxx.param.ParamTaskProcessor]:178 could not extract ResultSet; nested exception is org.hibernate.exception.JDBCConnectionException: could not extract ResultSet 
org.springframework.dao.DataAccessResourceFailureException: could not extract ResultSet; nested exception is org.hibernate.exception.JDBCConnectionException: could not extract ResultSet
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:257)
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:491)
	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:133)
	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.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy193.findAll(Unknown Source)
	..............

could not extract ResultSet 这个异常应该是实体类与数据库的字段写法不一致导致的或者是sql中的字段与数据库的不一致，主要检查实体类和数据库字段以及SQL

 

 

 

醇醛酸酯
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
报错org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet； SQL
weixin_47192515的博客
05-20 7529
org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet 问题原因： 这个错误是由无法找到数据库与实体类对应的字段导致异常的： 在控制台看见：突然想起mysql好像是不区分大
SQLGrammarException异常处理办法
qq_43358385的博客
02-06 4922
SQLGrammarException异常处理办法could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarExce
springboot连接oracle异常java.sql.SQLRecoverableException: IO Error: Connection reset by peer
ViewDa的博客
09-28 2527
java.sql.SQLRecoverableException: IO Error: Connection reset by peer Caused by: java.io.IOException: Connection reset by peer org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 17002, SQLState: 08006 javax.persistence.PersistenceException: o.
could not extract ResultSet----Table ‘sell.product_category‘ doesn‘t exist
Silly011的博客
11-20 697
org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.springframework.orm.jpa.vendor.HibernateJpaDialect.
怎样实现关闭connection时自动关闭Statement和ResultSet (下篇)
04-26
这篇博客的下篇主要讨论了如何在关闭Connection时自动关闭Statement和ResultSet，以确保资源的有效释放，防止内存泄漏。以下是对这个主题的详细解释。 首先，我们需要理解数据库连接、Statement和ResultSet在JDBC中...
描述Connection、Statement、ResultSet接口的作用
03-25
描述Connection、Statement、ResultSet接口的作用
ResultSet 转为listmap
03-03
为了方便数据处理和使用，我们需要将 ResultSet 转为 List，以便于后续的数据处理和展示。 下面是将 ResultSet 转为 List<Map> 的实现代码： ```java public static List,Object>> ResultSetToList(ResultSet rs) ...
java中ResultSet遍历数据操作
08-18
Java 中 ResultSet 遍历数据操作 在 Java 中，ResultSet 是一个常用的数据库查询结果集对象，它提供了遍历数据操作的功能，下面我们将对 ResultSet 遍历数据操作进行详细的介绍。 一、 获取数据库表的列名 在 ...
ResultSet转换为List的方法
08-10
需要注意的是，在将ResultSet转换为List对象时，我们需要考虑到性能和内存的使用，以避免出现性能问题和内存溢出问题。此外，我们还需要注意到数据类型的转换，以避免出现数据类型不匹配的问题。 将ResultSet转换为...
IO Error: Connection reset by peer: socket write error
SAm
12-07 595
起因： Tomcat6发布axis2 webservice开了一晚上就报这个错。   结果： 没重启，再执行一次就好了。   located HQL query plan in cache (from sg.com.abacus.pipe.pojo.TPipeIurDownload as a where a.queueNumber = '1' and a.lniata = 'test'...
oracle: A connection attempt failed because the connected party did not properly respond after a per
Jalen备忘录
07-28 2770
1. 报错信息 05:43:09.548 logback [http-nio-9996-exec-2] ERROR c.alibaba.druid.pool.DruidDataSource - discard connection java.sql.SQLRecoverableException: IO Error: A connection attempt failed because the connected party did not properly respond after a perio
LTS原理--TaskTracker任务处理（四）
井底之蛙
09-24 3219
TaskTracker主要的功能是执行任务，其有两点操作： （1）当TaskTracker启动时会根据当前TaskTracker资源定时向JobTracker （2）TaskTracker接收到JobTracker推送的任务执行任务。 参考LTS原理--JobTracker任务接收与分配（三） 一、示例： 地址：https://github.com/ltsopensource/lts-e...
MySQL表加字段可为null导致ArrayIndexOutOfBoundsException报错问题记录
lonelymanontheway的博客
10-28 2099
ArrayIndexOutOfBoundsException问题分析
could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could
MrZhang的博客
03-20 9187
1报错： could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet // 标记资源的statu为 -999 basResourceRepo.updateStatusByResId(recId); 就一个upda...
Mysql连接超时解决方案1: 修改默认超时时间
热门推荐
0945v1
02-27 2万+
MySQL数据库一般默认的连接超时时间为28800s(即8小时)，但是在进行大规模的线程事务操作时，一个连接会一直等待执行，这时候如果数据库的超时时间设置的过短，就可能会出现Mysql数据连接自动被释放，影响后面对数据库的操作。 当然MySQL连接设置的大小，要根据需求场景进行设置，wait_timeout过大也有弊端，其体现就是MySQL里大量的SLEEP进程无法及时释放，拖累系统性能，不过也...
关于hibernate 实体没有主键调用save方法报错could not extract ResultSet的解决办法
weixin_34247032的博客
04-22 356
最近写的项目是用的hibernate，由于是第一次用，也出现了一些问题，网上也没有查到相关的内容。废话也不多说了，下面来看今天遇见的这个问题。 我们在写项目的时候，经常会用到一些没有主键的关系表，而hibernate呢必须给实体类指定主键。所以我们在实体类里面加入注解@Id就可以了 加入注解后，项目可以正常的启动，但是在调用hibernate的save方法的时候会报一个could not...
tomcat数据源连接失效问题导致应用停顿
wendrewshay
08-04 3380
转载请注明：http://blog.csdn.net/wendrewshay/article/details/76687108
could not extract resultset yo
最新发布
07-28
引用\[1\]: could not extract ResultSet; SQL \[n/a\]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet 。 引用\[2\]:今天本地postman测试，出现这样错误："msg": "could not extract ResultSet; SQL \[n/a\]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet", 。 引用\[3\]:访问API返回结果： { "status": 500, "error": "Internal Server Error", "message": "could not extract ResultSet; SQL \[n/a\]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet", } 解决方法： 。 问题: could not extract resultset 是什么意思？如何解决这个问题？ 回答: "could not extract ResultSet"是一个错误信息，意味着无法提取结果集。这个错误通常与数据库查询有关，可能是由于SQL语法错误或数据库连接问题导致的。解决这个问题的方法包括检查SQL语句的正确性，确保数据库连接正常，以及查看相关的错误日志以获取更多详细信息。 #### 引用[.reference_title] - *1* [SQLGrammarException异常处理办法](https://blog.csdn.net/qq_43358385/article/details/113712604)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item] - *2* [could not extract ResultSet错误](https://blog.csdn.net/ZJUsunbin/article/details/79449825)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item] - *3* [请求数据库报错：“could not extract ResultSet； SQL [n/a]； nested exception is org.hibernate....](https://blog.csdn.net/qq_41577750/article/details/125545241)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值