• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

JDBC Connection Error

New Here ,
Feb 02, 2015 Feb 02, 2015

Copy link to clipboard

Copied

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:28)

    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.java: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.java: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(FilterSecurityInterceptor.java:107)

    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.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(AnonymousProcessingFilter.java:125)

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

    at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.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(HttpSessionContextIntegrationFilter.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.java: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(WrappedFilterChain.java:97)

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

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

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

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

    at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.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(WrappedFilterChain.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(FusionReactorStaticFilter.java:53)

    at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.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.java: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

Views

369

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation
Resources
Documentation