报错信息如下:
错误信息:select data error.No more data to read from socket
Caused exception message is: No more data to read from socket
错误详细堆栈信息:com.kingdee.bos.dao.ormapping.SQLAccessException: select data error.No more data to read from socket
Caused exception message is: No more data to read from socket
----------------------------------------------------------------------------------
原因分析:
select data error.No more data to read from socket Caused exception message is: No more data to read from socket 原因分析:Oracle 11g数据库优化器(optimizer_features_enable)的版本是11.2.0.1。使用该版本的优化器会造成执行过长的SQL语句报错,终止应用的运行
----------------------------------------------------------------------------------
解决方案一:
重启数据库 此办法可以迅速解决问题(临时)
解决方案二:
修改Oracle 11g数据库的优化器的版本为10.2.0.4,修改方法如下(无需重启数据库即可生效) SQL>alter system set optimizer_features_enable='10.2.0.4';