0 Replies Latest reply on Feb 2, 2015 12:42 PM by ChadFenske

    JDBC Connection Error

    ChadFenske

      We have a jdbc datasource setup to a DB2 database that works fine for about 6 days and then we get the error I've included below. If we restart the ColdFusion service the data source starts working again. I have searched google with no luck, has anyone ever seen this before?

       

      We are running ColdFusion 11 64 bit on Windows 2012 server.

       

      "Error","ajp-bio-8016-exec-4","01/28/15","23:15:00","project","Error Executing Database Query.System or internal error java.net.SocketException: Software caused connection abort: socket write error The specific sequence of files included or processed is: \\ourServerName\directoryName\index.cfm, line: 77 "

      coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.

          at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)

          at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:745)

          at cfrunwinextract2ecfm2052252949.runPage(\\ourServerName\directoryName\index.cfm:77)

          at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)

          at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)

          at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)

          at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)

          at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)

          at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:487)

          at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)

          at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)

          at coldfusion.filter.PathFilter.invoke(PathFilter.java:141)

          at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)

          at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)

          at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:2 8)

          at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)

          at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)

          at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)

          at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)

          at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)

          at coldfusion.CfmServlet.service(CfmServlet.java:219)

          at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j ava:303)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

          at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42 )

          at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j ava:241)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

          at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java :265)

          at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityIntercepto r.java:107)

          at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityIntercep tor.java:72)

          at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java :275)

          at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java: 124)

          at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java :275)

          at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java: 124)

          at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java :275)

          at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcess ingFilter.java:125)

          at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java :275)

          at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContex tHolderAwareRequestFilter.java:81)

          at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java :275)

          at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)

          at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java :275)

          at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)

          at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java :275)

          at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContext IntegrationFilter.java:249)

          at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java :275)

          at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)

          at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j ava:241)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

          at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

          at java.lang.reflect.Method.invoke(Unknown Source)

          at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterCha in.java:97)

          at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorR equestHandler.java:472)

          at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest( FusionReactorRequestHandler.java:312)

          at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(Fusio nReactorRequestHandler.java:192)

          at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorR equestHandler.java:507)

          at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCor eFilter.java:36)

          at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

          at java.lang.reflect.Method.invoke(Unknown Source)

          at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterCha in.java:79)

          at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

          at java.lang.reflect.Method.invoke(Unknown Source)

          at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactor StaticFilter.java:53)

          at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChai nPointCut.java:41)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422)

          at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:198)

          at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.jav a:607)

          at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

          at java.lang.Thread.run(Unknown Source)

      Caused by: java.sql.SQLException: System or internal error java.net.SocketException: Software caused connection abort: socket write error

          at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:448)

          at com.informix.jdbc.IfxSqli.b(IfxSqli.java:1243)

          at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2156)

          at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2132)

          at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:378)

          at com.informix.jdbc.IfxStatement.a(IfxStatement.java:1299)

          at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1269)

          at com.informix.jdbc.IfxStatement.c(IfxStatement.java:989)

          at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:907)

          at com.intergral.fusionreactor.jdbc.StatementSurrogate.execute(StatementSurrogate.java:61)

          at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)

          at coldfusion.sql.Executive.executeQuery(Executive.java:1481)

          at coldfusion.sql.Executive.executeQuery(Executive.java:1231)

          at coldfusion.sql.Executive.executeQuery(Executive.java:1161)

          at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)

          at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1158)

          at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:790)

          ... 81 more