oracle 连接失效异常错误：没有更多数据可从套接字读取

llmtgqce  于 2022-11-22  发布在  Oracle
关注(0)|答案(1)|浏览(471)

我们使用Oracle作为应用程序的数据库。

出版日期：

应用程序大部分时间运行良好，但我们间歇性地收到“No more data to read from socket”错误。
我们以前从来没有遇到过这个错误。最近我们有数据库从Oracle 11g升级到Oracle 12c。我们改变了ojdbc驱动程序jar版本。
现在我们断断续续地面临着以下问题。
这可能是因为ojdbc jar版本？或者DB？或Websphere需要更正的任何内容？

版本：

甲骨文：Oracle12c
ojdbc jar文件：ojdbc7
JDK版本：1.7
服务器：Websphere应用程序服务器8.5

例外状况：

org.springframework.dao.DataAccessResourceFailureException: could not execute query; nested exception is org.hibernate.exception.JDBCConnectionException: could not execute query
    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:631) ~[spring-orm-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:104) ~[spring-orm-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:403) ~[spring-orm-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58) ~[spring-tx-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) ~[spring-tx-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163) ~[spring-tx-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at com.sun.proxy.$Proxy65.loadRequest(Unknown Source) ~[na:na]
    at com.domain.service.implementation.myServiceImplementation.getDataFromDao(MyServiceImplementation.java:67)
Caused by: org.hibernate.exception.JDBCConnectionException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:99) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.loader.Loader.doList(Loader.java:2297) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2172) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.loader.Loader.list(Loader.java:2167) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:448) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241) ~[hibernate-entitymanager-3.5.3-Final.jar:3.5.3-Final]
    at com.domain.dao.implementation.MyDaoImplementation.loadRequest(<yDaoImplementation.java:126)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95) ~[na:1.7.0]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56) ~[na:1.7.0]
    at java.lang.reflect.Method.invoke(Method.java:620) ~[na:2.6 (10-07-2015)]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319) [spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155) ~[spring-tx-3.1.3.RELEASE.jar:3.1.3.RELEASE]
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: No more data to read from socket
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:86) ~[na:1.7.0]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:58) ~[na:1.7.0]
    at java.lang.reflect.Constructor.newInstance(Constructor.java:542) ~[na:2.6 (10-07-2015)]
    at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:627) ~[rsahelpers.jar:WAS855.SERV1 [cf081545.03]]
    at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:686) ~[rsahelpers.jar:WAS855.SERV1 [cf081545.03]]
    at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2267) ~[com.ibm.ws.runtime.jar:na]
    at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1191) ~[com.ibm.ws.runtime.jar:na]
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:728) ~[com.ibm.ws.runtime.jar:na]
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1849) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.loader.Loader.doQuery(Loader.java:718) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.loader.Loader.doList(Loader.java:2294) ~[hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    ... 209 common frames omitted
[7/31/17 16:33:32 ] SystemOut     16:33:32.249 [WebContainer : 2] ERROR o.h.transaction.JDBCTransaction - Could not toggle autocommit
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
    at com.ibm.ws.rsadapter.jdbc.WSJdbcWrapper.createClosedException(WSJdbcWrapper.java:122) ~[com.ibm.ws.runtime.jar:na]
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.activate(WSJdbcConnection.java:2901) ~[com.ibm.ws.runtime.jar:na]
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:3477) ~[com.ibm.ws.runtime.jar:na]
    at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:228) [hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:220) [hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:196) [hibernate-core-3.5.3-Final.jar:3.5.3-Final]
    at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:107) [hibernate-entitymanager-3.5.3-Final.jar:3.5.3-Final]
    at org.springframework.orm.jpa.JpaTransactionManager.doRollback(JpaTransactionManager.java:539) [spring-orm-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845) [spring-tx-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822) [spring-tx-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:410) [spring-tx-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:114) [spring-tx-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
    at com.domain.module.implementation.MyModuleImplementation.getListOfItems(MyModuleImplementation.java:54)
[7/31/17 16:33:32 ] LocalTranCoor E   WLTC0016E: Resource jdbc/ORACLEAPPL failed to complete. Exception stack trace follows: javax.transaction.xa.XAException
    at com.ibm.ejs.j2c.LocalTransactionWrapper.rollback(LocalTransactionWrapper.java:421)
    at com.ibm.tx.ltc.impl.LocalTranCoordImpl.cleanup(LocalTranCoordImpl.java:1016)
    at com.ibm.tx.ltc.impl.LocalTranCoordImpl.end(LocalTranCoordImpl.java:1195)
    at com.ibm.ws.webcontainer.collaborator.WebAppTransactionCollaboratorImpl.postInvoke(WebAppTransactionCollaboratorImpl.java:334)
    at com.ibm.wsspi.webcontainer.collaborator.CollaboratorHelper.postInvokeCollaborators(CollaboratorHelper.java:574)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1267)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:940)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:287)
    at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.determineNextChannel(SSLConnectionLink.java:1049)
    at com.ibm.ws.ssl.channel.impl.SSLConnectionLink$MyReadCompletedCallback.complete(SSLConnectionLink.java:643)
    at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
Caused by: com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: No more data to read from socket.
    at com.ibm.ws.rsadapter.AdapterUtil.translateSQLException(AdapterUtil.java:1584)
    at com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl.rollback(WSRdbSpiLocalTransactionImpl.java:628)
    at com.ibm.ejs.j2c.LocalTransactionWrapper.rollback(LocalTransactionWrapper.java:401)
    ... 24 more
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: No more data to read from socket DSRA0010E: SQL State = 08000, Error Code = 17,410
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:86)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:58)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:542)
    at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:627)
    at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:686)
    at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2267)
    ... 27 more
---- Begin backtrace for Nested Throwables
java.sql.SQLRecoverableException: No more data to read from socket DSRA0010E: SQL State = 08000, Error Code = 17,410
    at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
    at oracle.jdbc.driver.T4C7Ocommoncall.doOROLLBACK(T4C7Ocommoncall.java:68)
    at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:725)
    at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3970)
    at oracle.jdbc.OracleConnectionWrapper.rollback(OracleConnectionWrapper.java:145)
    at com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl.rollback(WSRdbSpiLocalTransactionImpl.java:607)
    at com.ibm.ejs.j2c.LocalTransactionWrapper.rollback(LocalTransactionWrapper.java:401)
    at com.ibm.tx.ltc.impl.LocalTranCoordImpl.cleanup(LocalTranCoordImpl.java:1016)
    at com.ibm.tx.ltc.impl.LocalTranCoordImpl.end(LocalTranCoordImpl.java:1195)
    at com.ibm.ws.webcontainer.collaborator.WebAppTransactionCollaboratorImpl.postInvoke(WebAppTransactionCollaboratorImpl.java:334)
    at com.ibm.wsspi.webcontainer.collaborator.CollaboratorHelper.postInvokeCollaborators(CollaboratorHelper.java:574)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1267)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:940)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:287)
    at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.determineNextChannel(SSLConnectionLink.java:1049)
    at com.ibm.ws.ssl.channel.impl.SSLConnectionLink$MyReadCompletedCallback.complete(SSLConnectionLink.java:643)
    at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
[7/31/17 16:33:32] 0000011b WSRdbManagedC W   DSRA0180W: Exception detected during ManagedConnection.destroy().  The exception is:  com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: No more data to read from socket. with SQL State : 08000 SQL Code : 17410
    at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
    at oracle.jdbc.driver.T4C7Ocommoncall.doOROLLBACK(T4C7Ocommoncall.java:68)
    at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:725)
    at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3970)
    at oracle.jdbc.OracleConnectionWrapper.rollback(OracleConnectionWrapper.java:145)
    at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:4690)
    at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3833)
    at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:2087)
    at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:776)
    at com.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:527)
    at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:2903)
    at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2608)
    at com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletion(LocalTransactionWrapper.java:1295)
    at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.driveSynchronization(LocalTranCoordImpl.java:581)
    at com.ibm.tx.ltc.embeddable.impl.EmbeddableLocalTranCoordImpl.informSynchronizations(EmbeddableLocalTranCoordImpl.java:220)
    at com.ibm.tx.ltc.impl.LocalTranCoordImpl.cleanup(LocalTranCoordImpl.java:1063)
    at com.ibm.tx.ltc.impl.LocalTranCoordImpl.end(LocalTranCoordImpl.java:1195)
    at com.ibm.ws.webcontainer.collaborator.WebAppTransactionCollaboratorImpl.postInvoke(WebAppTransactionCollaboratorImpl.java:334)
    at com.ibm.wsspi.webcontainer.collaborator.CollaboratorHelper.postInvokeCollaborators(CollaboratorHelper.java:574)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1267)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:940)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:287)
    at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.determineNextChannel(SSLConnectionLink.java:1049)
    at com.ibm.ws.ssl.channel.impl.SSLConnectionLink$MyReadCompletedCallback.complete(SSLConnectionLink.java:643)
    at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
Caused by: java.sql.SQLRecoverableException: No more data to read from socket DSRA0010E: SQL State = 08000, Error Code = 17,410
    ... 41 more
oracle

1条答案

按热度按时间
jaxagkaj

jaxagkaj1#

这个错误表示数据库的联机突然中断。我会尝试更新您的JDBC驱动程序，因为您使用的是11g驱动程序搭配12c数据库。一般而言，您的数据库和驱动程序版本应该相符。可能有其他的根本原因，例如防火墙逾时切断联机，但由于您最近升级了数据库，我会从升级驱动程序开始。

赞(0）分享  回复(0）举报  2022-11-22
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com