应用启动报错，无法连接数据库java.sql.SQLRecoverableException: No more data to read from socket

LingDong Jey 2020-05-20 01:04:06
日志输出：


2020-05-20 12:51:02

[ERROR]-[Thread: localhost-startStop-1]-[com.alibaba.druid.pool.DruidDataSource.init()]: init datasource error, url: jdbc:oracle:thin:@x.x.x.x:1521:orcl

java.sql.SQLRecoverableException: No more data to read from socket

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)

        at oracle.jdbc.driver.T4C8TTIdty.receive(T4C8TTIdty.java:669)

        at oracle.jdbc.driver.T4C8TTIdty.doRPC(T4C8TTIdty.java:576)

        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1166)

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)

        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)

        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)

        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461)

        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525)

        at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:734)

        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1060)

        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1056)

        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:104)

        at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:43)

        at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:226)

        at com.jfinal.core.Config.startPlugins(Config.java:128)

        at com.jfinal.core.Config.configPluginWithOrder(Config.java:71)

        at com.jfinal.core.Config.configJFinal(Config.java:56)

        at com.jfinal.core.JFinal.init(JFinal.java:63)

        at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

        at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)

        at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)

        at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)

        at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4958)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5652)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)

        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)

        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1260)

        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:2002)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        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)



2020-05-20 12:51:02

[ERROR]-[Thread: localhost-startStop-1]-[com.alibaba.druid.pool.DruidDataSource.init()]: {dataSource-2} init error

java.sql.SQLRecoverableException: No more data to read from socket

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)

        at oracle.jdbc.driver.T4C8TTIdty.receive(T4C8TTIdty.java:669)

        at oracle.jdbc.driver.T4C8TTIdty.doRPC(T4C8TTIdty.java:576)

        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1166)

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)

        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)

        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)

        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461)

        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525)

        at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:734)

        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1060)

        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1056)

        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:104)

        at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:43)

        at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:226)

        at com.jfinal.core.Config.startPlugins(Config.java:128)

        at com.jfinal.core.Config.configPluginWithOrder(Config.java:71)

        at com.jfinal.core.Config.configJFinal(Config.java:56)

        at com.jfinal.core.JFinal.init(JFinal.java:63)

        at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

        at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)

        at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)

        at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)

        at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4958)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5652)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)

        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)

        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1260)

        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:2002)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        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)



2020-05-20 12:51:02

[ERROR]-[Thread: localhost-startStop-1]-[com.jfinal.core.Config.startPlugins()]: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. 

java.sql.SQLRecoverableException: No more data to read from socket

com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLRecoverableException: No more data to read from socket

        at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:55)

        at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:226)

        at com.jfinal.core.Config.startPlugins(Config.java:128)

        at com.jfinal.core.Config.configPluginWithOrder(Config.java:71)

        at com.jfinal.core.Config.configJFinal(Config.java:56)

        at com.jfinal.core.JFinal.init(JFinal.java:63)

        at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49)

        at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)

        at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)

        at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)

        at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4958)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5652)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)

        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)

        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1260)

        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:2002)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        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.sql.SQLRecoverableException: No more data to read from socket

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)

        at oracle.jdbc.driver.T4C8TTIdty.receive(T4C8TTIdty.java:669)

        at oracle.jdbc.driver.T4C8TTIdty.doRPC(T4C8TTIdty.java:576)

        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1166)

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)

        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)

        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)

        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461)

        at com.alibaba.druid.pool.Dr
...全文
2035 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复
Oracle 错误 java.sql.SQLRecoverableException: No more data to read from socket
周末的时候Java程序的连接池突然出问题，报错如下所示。 java.sql.SQLRecoverableException: No more data to read from socket 此问题不是特定的页面存在，而是所有连接数据库查询的功能均报错 先确定一下排查的思路吧， 1.周五的时候确实我们有新的功能上线，所以首先排查是否是新功能影响了连接的释放，结果确定不是。 2.是否是因为工具类或者公用方法被修改导致数据库连接问题，结果确定没有修改。 经过网上查找资料和其他渠道，得知此问题
(精)java.sql.SQLException: No more data to read from socket
dbcp (Oracle)重新链接的问题 - Cause: java.sql.SQLException: No more data to read from socket老是出现这个No more data to read from socket问题（ibatis＋spring）。该异常通常是因为使用了连接池，当从连接池取得的connection失效或者超时的时候，使用这个连接来进行数据库操作就会
java.sql.SQLException: No more data to read from socket
java.sql.SQLException: No more data to read from socket怀疑是Oracle服务器的环境故障，导致会话被服务端关闭。排查思路：1，Oracle 的 SQLNET.EXPIRE_TIME 设置是否合理？2，Oracle 服务器的 ulimit 设置不足？3，Oracle 连接池超限？查看连接数，可以参考：https://blog.csdn.net/...
【解决】dbcp (Oracle)重新连接的问题 Cause: java.sql.SQLException: No more data to read from socket
dbcp (Oracle)重新链接的问题 - Cause: java.sql.SQLException: No more data to read from socket 1、问题 业务开发中使用dbcp做连接池，在一次oracle数据库重启后一直报错，老是出现这个Cause: java.sql.SQLException: No more data to read from socket问题（mybatis＋spring）。 重启服务后正常。 2、原因 该异常通常是因为使用了连接池，当从连接池取得
No more data to read from socket问题
2012-05-19 14:37:39,244 ERROR: [http-bio-9604-exec-222] [BaseRootDAO.executeQueryByPS]throw SQL Exception ->No more data to read from socket java.sql.SQLRecoverableException: No more data to read fro
Java EE

67,513

社区成员

225,879

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章