- 浏览: 188099 次
- 性别:
- 来自: 北京
最新评论
-
WH_LPWH:
哥呀 牛逼 大赞一个
使用JAVA写出DBF出现乱码和数据错位 -
z390174504:
不错啊...ID和hide不能一样,多谢
后台取不到extJs2.3的comboBox手写输入的值 -
三里小龙:
<div class="quote_title ...
java.sql.SQLException: 无法从套接字读取更多的数据 -
linwei_211:
<div class="quote_title ...
java.sql.SQLException: 无法从套接字读取更多的数据 -
三里小龙:
mysql也会出现类似的情况,但这个理由有点牵强附会
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......所以抛出了那个错。我试了一下,批量删除的时候,不去操作查询,控制台果然不报那个错了。我的问题算是告一段落了,但是这个异常到底是因为什么呢,众说纷纭,由他去吧......
评论
我没说是哪个理由吧,具体原因我也没搞清楚,只是把自己解决问题的各种过程分享下...
呵呵,是的,不过你说的那几种出现这种情况的原因还真遇到过。有的时候可能是我们在做数据删除的时候没有去给数据加锁,所以在做检索的时候可能就会因为并发出现类似的异常。就像你说的,情况真的有很多种,谢谢分享
我没说是哪个理由吧,具体原因我也没搞清楚,只是把自己解决问题的各种过程分享下...
发表评论
-
plsql注册机
2012-08-30 11:05 916plsql注册机 可以随即生成plsql的序列号 ... -
hibernate在DB2数据库上使用报DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601的解决
2012-08-29 14:41 10959前一段时间在做一个项目时,遇到同样的代码在连接ora ... -
自定义聚合函数以及字符串连接超长的解决
2012-08-29 13:09 8631Oracle的定制功能十分强大。前几天在碰到一个问题的时候,查 ... -
java.sql.SQLException: 数据大小超出此类型的最大值
2012-06-07 18:04 8078一、异常情况: 有了一定Java编程经验之后,一般都使用 ... -
中文与asc码互转最快的办法
2012-03-09 11:52 7867我们在开发使时 ... -
Tomcat中因时区设置问题导致与系统时间不一致问题
2011-10-27 16:33 2771今天在调试一个项目时发现用户那里服务器的Tomcat ... -
使用JAVA写出DBF出现乱码和数据错位
2011-10-21 17:25 7639最近在做项目 ... -
jasperreports打印word格式报表的问题
2011-10-21 12:06 2801使用jar包jasperreports-1.3.2 ... -
Oracle 10g SGA结构
2011-10-21 10:42 11361.实例与数据库实例(instance) 运行中的数据库,即内 ... -
WindowsXP下完全卸载oracle10g
2011-08-19 14:33 1012oracle10g 卸载 软件 ... -
判断字符串中是否含有中文
2011-08-19 11:06 4165//判断字符串中是否含有中文 publi ... -
java截取字符串
2011-08-19 11:03 1377** * 输入一个字符串和字节数,输出为按字节截取的字条符串 ... -
eclipse输入点号没有提示解决大全
2011-08-19 11:02 4160前几天下载了Eclipse3.3和MyEclipse6玩了一下 ... -
java开发环境变量配置
2011-08-19 10:56 968我的电脑--属性--高级--环境变量 ANT_HOME D:\ ... -
Windows DOS窗体下Oracle 数据库的导入导出(IMPEXP)命令
2011-08-19 10:52 1129oracle 用户创建 数据库的导入导出imp/exp 可以 ... -
java-利用dom4j操作(写)xml文件
2011-08-19 10:09 964public void write(String cusxml ... -
sequence避免主键唯一约束
2011-08-19 10:01 1163---为某个新加的表创建序列 create sequence ... -
ORACLE常用傻瓜问题1000问
2011-08-19 09:58 1107ORACLE常用傻瓜问题1000问 1. Oracle安 ...
相关推荐
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK ……
NULL 博文链接:https://listen-raining.iteye.com/blog/1962065
在oracle里面运行一下,解决Exception java.sql.SQLException ORA-00600 内部错误代码
NULL 博文链接:https://zhang-zling.iteye.com/blog/980488
服务器出现java.sql.SQLException No suitable driver found for 的
java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错: 解决方法: 1,登陆服务器 mysql> use mysql; //用mysql ...
oracle ora-各种常见java.sql.SQLException归纳
本文主要介绍了关于MySQL存储表情报错:java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x92\xA9\x0D\x0A…’的相关解决方法,分享出供大家参考学习,下面话不多说了,来一起看看详细的介绍: ...
oracle 10g 数据库驱动下载:oracle jdbc dirver
主要给大家介绍了关于MySQL存储表情时报错:java.sql.SQLException: Incorrect string value: 'xF0x9Fx92xA9x0Dx0A...'的解决方法,文中通过示例代码介绍的非常详细,需要的朋友可以参考借鉴,下面来一起看看吧。
Q: I am working with ... I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
mysql5.6连接驱动jaf,可处理报错java.sql.SQLException: No suitable driver
java.sql.SQLException: Operation not allowed after ResultSet closed java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection should be passed in
异常错误:java.sql.SQLException: The server time zone value ‘?й???’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTime...
问题是这样的…我在VS2008直接运行打开网页,可以连接... 异常详细信息: System.Data.SqlClient.SqlException: 无法打开登录所请求的数据库 “TakeClass”。登录失败。 用户 ‘2D2727E2578F446\ASPNET’ 登录失败。
该用户与可信 SQL Server 连接无关联。 说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient....
import java.sql.SQLException; import java.sql.Statement; import java.sql.ResultSet; /** * @author Administrator * */ public class sqlServer { String DBDriver=...
Caused by: java.sql.SQLException: java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver at com.trs.gateway.commons.hive.HiveFeature.getConnection(HiveFeature.java:57) at ...
绝对好用的9i驱动包+10g驱动包 解决java.sql.SQLException: 不支持的特性 解决oracle.jdbc.driver.OracleDatabaseMetaData.supportsGetGeneratedKeys()Z异常 等等