java.sql.SQLException: Io 异常: Socket closed
Struts+Hibernate+Spring开发的,数据库是Oracle,服务器resin
500 Servlet Exception
java.sql.SQLException: Io 异常: Socket closed
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:511)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:941)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:531)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2945)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:75)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:85)
我也遇到了 当点击一个可能查询加载慢的晌咐页面 连续点击几次后就socket关闭,然后出现返回空值等等问题,但是奇怪的是,过一段时间再刷新时,又正常了,再这样刷几次,又出同样的问题,
我是数据量有600W,查询sql慢使得页面加载慢,连续刷激谨培新就socket关闭,目前想到的就是让他不连续刷新那明唯么快,完成一次连接后再去连接。
Socket closed
套接字关闭啊... 是你连数据库的问题