java.sql.SQLException: 无法从套接字读取更多的数据

今天在用公司自己做的项目的一个功能时，我是在删除数据的时候报的错误，删除的数据量为203360条，数据成功删除了，tomcat6.0控制台报了一个异常，如下：

[c3p0] A PooledConnection that has already signalled a Connection error is still in use!
[esoaisapp] WARN 2011-10-21 11:09:08,765 method:com.mchange.v2.c3p0.impl.NewPooledConnection.handleThrowable(NewPooledConnection.java:426)
[c3p0] Another error has occurred [ java.sql.SQLException: 无法从套接字读取更多的数据: Software caused connection abort: socket write error ] which will not be reported to listeners!
java.sql.SQLException: Io 异常: Software caused connection abort: socket write error
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
 at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3678)
 at oracle.jdbc.ttc7.TTC7Protocol.rollback(TTC7Protocol.java:505)
 at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1444)
 at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
 at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:163)
 at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:142)
 at cn.flyingsoft.oais.driver.data.relevance.dao.impl.EssDataRelevanceDaoHibernate.deleteFormOrTo(EssDataRelevanceDaoHibernate.java:419)
 at cn.flyingsoft.oais.driver.data.relevance.DataRelevanceManager.deleteFormOrTo(DataRelevanceManager.java:67)
 at cn.flyingsoft.oais.service.data.relevance.manager.impl.DataRelevanceService.deleteFormOrTo(DataRelevanceService.java:117)
 at cn.flyingsoft.oais.webapp.action.manage.metadata.BusinessEditAction.childDataBatchDelete(BusinessEditAction.java:7132)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
 at cn.flyingsoft.oais.webapp.struts.PkgBaseAction.dispatchMyMethod(PkgBaseAction.java:137)
 at cn.flyingsoft.oais.webapp.struts.PkgBaseAction.execute(PkgBaseAction.java:87)
 at cn.flyingsoft.oais.webapp.action.manage.metadata.BusinessEditAction.execute(BusinessEditAction.java:246)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
 at cn.flyingsoft.oais.webapp.struts.RequestDynamicProcessor.process(RequestDynamicProcessor.java:114)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.ActionFilter.doFilter(ActionFilter.java:88)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:323)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.GZIPFilter.doFilter(GZIPFilter.java:49)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:75)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at com.opensymphony.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:42)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292)
 at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:108)
 at org.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:197)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:143)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:154)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:50)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:246)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
 at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:45)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 at java.lang.Thread.run(Thread.java:595)
[esoaisapp] WARN 2011-10-21 11:09:08,828 method:com.mchange.v2.c3p0.impl.NewPooledConnection.handleThrowable(NewPooledConnection.java:425)
[c3p0] A PooledConnection that has already signalled a Connection error is still in use!
[esoaisapp] WARN 2011-10-21 11:09:08,828 method:com.mchange.v2.c3p0.impl.NewPooledConnection.handleThrowable(NewPooledConnection.java:426)
[c3p0] Another error has occurred [ java.sql.SQLException: 关闭的连接 ] which will not be reported to listeners!
java.sql.SQLException: 关闭的连接
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
 at oracle.jdbc.driver.OracleConnection.setAutoCommit(OracleConnection.java:1283)
 at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:881)
 at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:174)
 at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:166)
 at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:142)
 at cn.flyingsoft.oais.driver.data.relevance.dao.impl.EssDataRelevanceDaoHibernate.deleteFormOrTo(EssDataRelevanceDaoHibernate.java:419)
 at cn.flyingsoft.oais.driver.data.relevance.DataRelevanceManager.deleteFormOrTo(DataRelevanceManager.java:67)
 at cn.flyingsoft.oais.service.data.relevance.manager.impl.DataRelevanceService.deleteFormOrTo(DataRelevanceService.java:117)
 at cn.flyingsoft.oais.webapp.action.manage.metadata.BusinessEditAction.childDataBatchDelete(BusinessEditAction.java:7132)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
 at cn.flyingsoft.oais.webapp.struts.PkgBaseAction.dispatchMyMethod(PkgBaseAction.java:137)
 at cn.flyingsoft.oais.webapp.struts.PkgBaseAction.execute(PkgBaseAction.java:87)
 at cn.flyingsoft.oais.webapp.action.manage.metadata.BusinessEditAction.execute(BusinessEditAction.java:246)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
 at cn.flyingsoft.oais.webapp.struts.RequestDynamicProcessor.process(RequestDynamicProcessor.java:114)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.ActionFilter.doFilter(ActionFilter.java:88)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:323)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.GZIPFilter.doFilter(GZIPFilter.java:49)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:75)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at com.opensymphony.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:42)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292)
 at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:108)
 at org.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:197)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:143)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:154)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:50)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:246)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
 at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:45)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 at java.lang.Thread.run(Thread.java:595)
[esoaisapp] ERROR 2011-10-21 11:09:09,375 method:org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:178)
Could not toggle autocommit
java.sql.SQLException: 关闭的连接
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
 at oracle.jdbc.driver.OracleConnection.setAutoCommit(OracleConnection.java:1283)
 at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:881)
 at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:174)
 at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:166)
 at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:142)
 at cn.flyingsoft.oais.driver.data.relevance.dao.impl.EssDataRelevanceDaoHibernate.deleteFormOrTo(EssDataRelevanceDaoHibernate.java:419)
 at cn.flyingsoft.oais.driver.data.relevance.DataRelevanceManager.deleteFormOrTo(DataRelevanceManager.java:67)
 at cn.flyingsoft.oais.service.data.relevance.manager.impl.DataRelevanceService.deleteFormOrTo(DataRelevanceService.java:117)
 at cn.flyingsoft.oais.webapp.action.manage.metadata.BusinessEditAction.childDataBatchDelete(BusinessEditAction.java:7132)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
 at cn.flyingsoft.oais.webapp.struts.PkgBaseAction.dispatchMyMethod(PkgBaseAction.java:137)
 at cn.flyingsoft.oais.webapp.struts.PkgBaseAction.execute(PkgBaseAction.java:87)
 at cn.flyingsoft.oais.webapp.action.manage.metadata.BusinessEditAction.execute(BusinessEditAction.java:246)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
 at cn.flyingsoft.oais.webapp.struts.RequestDynamicProcessor.process(RequestDynamicProcessor.java:114)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.ActionFilter.doFilter(ActionFilter.java:88)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:323)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.GZIPFilter.doFilter(GZIPFilter.java:49)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:75)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at com.opensymphony.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:42)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292)
 at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:108)
 at org.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:197)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:143)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:154)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:50)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:246)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
 at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:45)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 at java.lang.Thread.run(Thread.java:595)
[esoaisapp] ERROR 2011-10-21 11:09:09,375 method:org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:148)
JDBC rollback failed
java.sql.SQLException: Io 异常: Software caused connection abort: socket write error
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
 at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3678)
 at oracle.jdbc.ttc7.TTC7Protocol.rollback(TTC7Protocol.java:505)
 at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1444)
 at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
 at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:163)
 at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:142)
 at cn.flyingsoft.oais.driver.data.relevance.dao.impl.EssDataRelevanceDaoHibernate.deleteFormOrTo(EssDataRelevanceDaoHibernate.java:419)
 at cn.flyingsoft.oais.driver.data.relevance.DataRelevanceManager.deleteFormOrTo(DataRelevanceManager.java:67)
 at cn.flyingsoft.oais.service.data.relevance.manager.impl.DataRelevanceService.deleteFormOrTo(DataRelevanceService.java:117)
 at cn.flyingsoft.oais.webapp.action.manage.metadata.BusinessEditAction.childDataBatchDelete(BusinessEditAction.java:7132)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
 at cn.flyingsoft.oais.webapp.struts.PkgBaseAction.dispatchMyMethod(PkgBaseAction.java:137)
 at cn.flyingsoft.oais.webapp.struts.PkgBaseAction.execute(PkgBaseAction.java:87)
 at cn.flyingsoft.oais.webapp.action.manage.metadata.BusinessEditAction.execute(BusinessEditAction.java:246)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
 at cn.flyingsoft.oais.webapp.struts.RequestDynamicProcessor.process(RequestDynamicProcessor.java:114)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.ActionFilter.doFilter(ActionFilter.java:88)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:323)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.GZIPFilter.doFilter(GZIPFilter.java:49)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:75)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at com.opensymphony.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:42)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292)
 at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:108)
 at org.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:197)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:143)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:154)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:50)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:246)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
 at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:45)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 at java.lang.Thread.run(Thread.java:595)
org.hibernate.TransactionException: JDBC rollback failed
 at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:150)
 at cn.flyingsoft.oais.driver.data.relevance.dao.impl.EssDataRelevanceDaoHibernate.deleteFormOrTo(EssDataRelevanceDaoHibernate.java:419)
 at cn.flyingsoft.oais.driver.data.relevance.DataRelevanceManager.deleteFormOrTo(DataRelevanceManager.java:67)
 at cn.flyingsoft.oais.service.data.relevance.manager.impl.DataRelevanceService.deleteFormOrTo(DataRelevanceService.java:117)
 at cn.flyingsoft.oais.webapp.action.manage.metadata.BusinessEditAction.childDataBatchDelete(BusinessEditAction.java:7132)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
 at cn.flyingsoft.oais.webapp.struts.PkgBaseAction.dispatchMyMethod(PkgBaseAction.java:137)
 at cn.flyingsoft.oais.webapp.struts.PkgBaseAction.execute(PkgBaseAction.java:87)
 at cn.flyingsoft.oais.webapp.action.manage.metadata.BusinessEditAction.execute(BusinessEditAction.java:246)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
 at cn.flyingsoft.oais.webapp.struts.RequestDynamicProcessor.process(RequestDynamicProcessor.java:114)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.ActionFilter.doFilter(ActionFilter.java:88)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:323)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.GZIPFilter.doFilter(GZIPFilter.java:49)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:75)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at com.opensymphony.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:42)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292)
 at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:108)
 at org.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:197)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:143)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:154)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:50)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:246)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220)
 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
 at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
 at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at cn.flyingsoft.oais.webapp.filter.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:45)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Io 异常: Software caused connection abort: socket write error
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
 at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3678)
 at oracle.jdbc.ttc7.TTC7Protocol.rollback(TTC7Protocol.java:505)
 at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:1444)
 at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
 at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:163)
 at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:142)
 ... 74 more

查看C:\oracle\product\10.2.0\admin\orcl\bdump下alert_orcl.log文件，发现

Thu Oct 20 14:49:50 2011
Thread 1 advanced to log sequence 681
  Current log# 2 seq# 681 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thu Oct 20 15:31:32 2011
Thread 1 advanced to log sequence 682
  Current log# 3 seq# 682 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thu Oct 20 15:39:01 2011
Thread 1 advanced to log sequence 683
  Current log# 1 seq# 683 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thu Oct 20 15:40:54 2011
Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4168.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7C34F937] [ADDR:0xCAA0000] [UNABLE_TO_WRITE] []

于是查看C:\oracle\product\10.2.0\admin\orcl\udump下orcl_ora_4168.trc文件，发现
        Repeat 1 times
336CDEC0 00000000 336CDEC4 336CDEC4 336CDD9C  [......l3..l3..l3]
336CDED0 336CDFFC 00000000 00000000 00000003  [..l3............]
336CDEE0 00000000 00000000 00000000 00000001  [................]
336CDEF0 00000059 00000059 0000005A 00000059  [Y...Y...Z...Y...]
336CDF00 0000005B 0000AD7B 00000000 41464544  [[...{.......DEFA]
336CDF10 00544C55 00000000 00000000 00000000  [ULT.............]
336CDF20 00000007 00000003 00002000 00000001  [......... ......]
336CDF30 00030003 336DC814 00000001 00000000  [......m3........]
336CDF40 00000000 03E4D50D 00000000 037C331F  [.............3|.]
336CDF50 00000000 0068A1EE 00000000 00000000  [......h.........]
336CDF60 00000000 00000000 00000000 00001F8C  [................]
336CDF70 00000000 00003BC4 00000000 00000000  [.....;..........]
336CDF80 00000000 00000000 00000000           [............]   
KCBS: disable_kcbsbpd is 0
KCBS: bufcnt = 4960, nb_kcbsds = 4960
KCBS: fbufcnt = 1092
KCBS: Tot bufs in set segwise
KCBS: nbseg[0] is 248
KCBS: nbseg[1] is 248
KCBS: nbseg[2] is 248
KCBS: nbseg[3] is 248
KCBS: nbseg[4] is 248
KCBS: nbseg[5] is 248
KCBS: nbseg[6] is 248
KCBS: nbseg[7] is 248
KCBS: nbseg[8] is 248
KCBS: nbseg[9] is 248
KCBS: nbseg[10] is 248
KCBS: nbseg[11] is 248
KCBS: nbseg[12] is 248
KCBS: nbseg[13] is 248
KCBS: nbseg[14] is 248
KCBS: nbseg[15] is 248
KCBS: nbseg[16] is 248
KCBS: nbseg[17] is 248
KCBS: nbseg[18] is 248
KCBS: nbseg[19] is 248
KCBS: Act cnt = 2759
KSOLS: Begin dumping all object level stats elements
KSOLS: Done dumping all elements. Exiting.
Dump event group for SESSION
Dump event group for SYSTEM
这只是部分信息，因为那个文件内容的却太长了，总共932289行，都是些看不懂的东东。
出了错，我肯定先看控制台下的这个异常是怎么回事吧。下面听我一一分析。我先百度了一下，看到了百度知道里有人提此问题，有最佳答案写到：

引起这种错误的原因很多，几点建议：
1、检查程序，优化数据库操作及SQL语句，如该关闭的数据库链接要及时关闭、查询语句该简化的简化；
2、检查网络状况，排除网络原因；
3、调整数据库配置参数，比如：会话超时时间、每秒最大连接数、最大连接数等等；
4、看看数据库的版本，有没有升级的可能，也许会解决这个问题；
      我心想之前一直用的这个版本oracle10G,版本10.2.0.1.0，代码也一直是这个代码，SQL自然也就自然是这个SQL，都没有此问题的出现啊，那就不应该是上述1、4的原因，我想寻找其他的解决方法，又点开了检索到的其他的网页，说的原因也大都说是SQL的问题或者数据库版本的问题，更有说是oracle8i,9i的bug，还有说是查了metaLink确定就是oracle的哪个哪个bug，BugID还写的清清楚楚，当然我也并不清楚metaLink是什么，我用的是oracle10G，而且才一年的时间，我当然更不敢怀疑这是伟大的甲骨文公司oracle的bug。于是考虑上述的原因2，不过也不大可能啊，因为出现这个以后，我还可以操作别的功能，那就证明数据库连接没有问题。
      于是，接着看网页，有说是驱动包的事（我的驱动是ojdbc14.jar），说是应该是getconnect的时候出的问题，连不上数据库，升级驱动包就可以了。有说是oracle回滚段设置的问题，有说是SGA设置的问题，还有说是表空间设置低的问题，还有说是oracle共享内存设置低的问题，还有说是数据库连接connect没有释放，还有说是PL/SQL版本的问题，PL/SQL5有此问题，我看了下我的PL/SQL的版本是7.1.1.1339，而且我又不是在PL/SQL里执行的SQL语句的时候报的这个错，也排除了这个因素。至于什么回滚段，SGA，我又不会设置。
     接着上Google继续寻找答案，因为百度我是不怎么完全相信的。从ITpub、ITEye、CSDN、CNOUR((China Oracle User Group))、DISCUZ(开发者乐园)、ChinaUnix....搜索答案，结果都跟上面差不多的，原因描述差不多，无非说是数据库的Bug，要升级数据库，或驱动包.....我实在不想是因为这个原因，我得怎么去说服我的领导，让他同意让我给去说服用户那是oracle的bug,然后给用户升级数据库。
     于是，我开始转移目光，不再只是搜索java.sql.SQLException: 无法从套接字读取更多的数据这个异常的答案。G了一下oracle日志文件报的那个错ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7C34F937] [ADDR:0xCAA0000] [UNABLE_TO_WRITE] []，有人说是不需搭理oracle的这个ORA-07445，说是oracle经常有事没事抛这么个错，说不影响业务。我也的确是觉得虽然控制台抛了这么个错，但是数据删除是完全没有问题的。但是人用户提了这个问题啊，我总不可能去这么告诉用户吧。
     干脆不再找答案了。我注意到用户是使用我们的批量操作功能同时删除203360条数据，本来这个批量删除是做成，用户一点批量删除的时候，就出来一个进度条，并且采用了遮罩，在删除这203360条数据的过程中，用户是不能进行其他操作的，必须等待这些数据完全删除掉，页面重新刷数据，并提示批量删除成功的时候，才可以进行其他操作。但是被一个同事处理成，用户一点批量删除的时候，不出现那个进度条了，他觉得用户可以在删除203360这些数据的这几分钟里干点别的事，所以故意隐藏了那个mask。于是删除数据的请求是发过去了，后台也一直在删数据库里的记录，这时候页面上数据还没刷新（因为不可能给他做成实时刷新的），用户又进行了查询操作，相当于又向数据库发送了请求，而前面的delete 还没完且正在进行中，这又来了一个select......所以抛出了那个错。我试了一下，批量删除的时候，不去操作查询，控制台果然不报那个错了。我的问题算是告一段落了，但是这个异常到底是因为什么呢，众说纷纭，由他去吧......

 

评论

3 楼 三里小龙 2013-08-27  

linwei_211 写道

三里小龙 写道

mysql也会出现类似的情况，但这个理由有点牵强附会

我没说是哪个理由吧，具体原因我也没搞清楚，只是把自己解决问题的各种过程分享下...

呵呵，是的，不过你说的那几种出现这种情况的原因还真遇到过。有的时候可能是我们在做数据删除的时候没有去给数据加锁，所以在做检索的时候可能就会因为并发出现类似的异常。就像你说的，情况真的有很多种，谢谢分享

2 楼 linwei_211 2013-08-27  

三里小龙 写道

mysql也会出现类似的情况，但这个理由有点牵强附会

我没说是哪个理由吧，具体原因我也没搞清楚，只是把自己解决问题的各种过程分享下...

1 楼 三里小龙 2013-05-28  

mysql也会出现类似的情况，但这个理由有点牵强附会