一段时间不活动后，出现“没有更多数据可从套接字读取"的信息. Weblogic和Oracle DB [英] I get 'No more data to read from socket' after a period of inactivity. Weblogic and Oracle DB

问题描述

我在连接到Oracle数据库的Weblogic服务器上部署了JSP Web应用程序.在weblogic服务器实例中没有设置数据源，并且应用程序自行(通过jdbc)与数据库进行通信.但是，每天早晨，当我尝试访问网页时，都会收到没有更多数据可从套接字读取"错误.我重置了weblogic服务器，一切恢复正常，但是事情是我不能每天早上都重新启动服务器. 无论如何，这可以自动修复吗?我认为这与池中的连接有关，可能是由oracle禁用的，但仍被应用程序认为是活动的...

I have a JSP web application deployed on a Weblogic server connected to an Oracle Database. There is no datasource set in the weblogic server instance and the application communicates with the database on it's own (with jdbc). However, every morning when I try to access the web page I get a 'No more data to read from socket' error. I reset the weblogic server and everything gets back to normal, but the thing is I can't keep restarting the server every morning. Is there anyway that this can be fixed automatically? I think it has something to do with the connections in the pool, probably being disabled by oracle but still considered active by the application...

谢谢

推荐答案

我确实设法纠正了这个问题.

I did manage to get this corrected.

我所做的是在Weblogic管理控制台中创建数据源，然后将我的应用程序配置为使用此数据源.最初它仍然给出错误，但是随后我取消了数据源事务选项中的本地事务后保持连接"复选框，从而解决了该问题.

What I did was creating a datasource in the Weblogic admin console and then configure my app to use this datasource. It was still giving the error initially but then I unchecked the "Keep Connection After Local Transaction" box from the datasource transaction options and this fixed the problem.

这篇关于一段时间不活动后，出现“没有更多数据可从套接字读取"的信息. Weblogic和Oracle DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！