0 Replies Latest reply on Jul 1, 2015 9:26 AM by joseph.yan

    Oracle JDBC error No more data available to read.

    joseph.yan

      Hi All,

       

      I am using Oracle connected to Coldfusion 10,0,15,292620 and suddenly I got JDBC Oracle error saying "No more data available to read".

      I am using Fusion Reactor and suddenly the query is taking 6844 ms from normal time about 160ms.

      Try for the second time and it is fine. So I am just wondering is this Coldfusion Oracle JDBC bug.

       

      Thanks

       

      Joseph.

       

      The error detail:

      java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available to read.

      [Macromedia][Oracle JDBC Driver]No more data available to read.

       

      The query statement:

      UPDATE sectors_slots

      SET

           xdoc_ids = <cfqueryparam cfsqltype="cf_sql_clob" value="#local.xDocIDs#" />,

           latest_version = <cfqueryparam cfsqltype="cf_sql_blob" value="#local.binaryJSON#" />,

           version_date = <cfqueryparam cfsqltype="cf_sql_timestamp" value="#local.dateNow#" />

      WHERE

           sector_id = <cfqueryparam cfsqltype="cf_sql_integer" value="#local.sectorID#" /> AND time_slot = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.sectorSlot#" />

       

      JDBC stack trace:

      macromedia.jdbc.oraclebase.ddcr.b(null:???)
      macromedia.jdbc.oraclebase.ddcr.a(null:???)
      macromedia.jdbc.oraclebase.ddcq.b(null:???)
      macromedia.jdbc.oraclebase.ddcq.a(null:???)
      macromedia.jdbc.oraclebase.ddcq.a(null:???)
      macromedia.jdbc.oracle.net8.ddk.c(null:???)
      macromedia.jdbc.oracle.ddam.t(null:???)
      macromedia.jdbc.oraclebase.dde3.w(null:???)
      macromedia.jdbc.oraclebase.dde3.s(null:???)
      macromedia.jdbc.oraclebase.dddz.execute(null:???)
      macromedia.jdbc.oraclebase.ddd2.execute(null:???)
      com.intergral.fusionreactor.jdbc.PreparedStatementSurrogate.execute(PreparedStatementSurrogate.java:224)
      coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
      coldfusion.sql.Executive.executeQuery(Executive.java:1467)
      coldfusion.sql.Executive.executeQuery(Executive.java:1201)
      coldfusion.sql.Executive.executeQuery(Executive.java:1131)
      coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
      coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
      coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
      cfModuleService2ecfc494738733$funcPREPARESECTORPUBLISH.runFunction(/var/www/html/com/industryintel/services/xdoc/ModuleService.cfc:590)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
      coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
      cfAlertListener2ecfc1660993880$funcPREPARESECTORS.runFunction(/var/www/html/commons/listeners/AlertListener.cfc:3379)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
      coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
      coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:402)
      cfEventInvoker2ecfc1458357037$funcINVOKELISTENER.runFunction(/var/www/html/supportCfusion/MachII/framework/invokers/EventInvoker.cfc:94)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
      coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428)
      cfNotifyCommand2ecfc269113347$funcEXECUTE.runFunction(/var/www/html/supportCfusion/MachII/framework/commands/NotifyCommand.cfc:95)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
      coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428)
      cfEventHandler2ecfc1598006774$funcHANDLEEVENT.runFunction(/var/www/html/supportCfusion/MachII/framework/EventHandler.cfc:88)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
      coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428)
      cfRequestHandler2ecfc1121342851$funcHANDLEEVENT.runFunction(/var/www/html/supportCfusion/MachII/framework/RequestHandler.cfc:386)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
      coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
      cfRequestHandler2ecfc1121342851$funcHANDLENEXTEVENT.runFunction(/var/www/html/supportCfusion/MachII/framework/RequestHandler.cfc:334)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
      coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
      cfRequestHandler2ecfc1121342851$funcPROCESSEVENTS.runFunction(/var/www/html/supportCfusion/MachII/framework/RequestHandler.cfc:278)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
      coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
      cfRequestHandler2ecfc1121342851$funcHANDLEREQUEST.runFunction(/var/www/html/supportCfusion/MachII/framework/RequestHandler.cfc:208)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
      coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428)
      cfmach2dii2ecfc39383740$funcHANDLEREQUEST.runFunction(/var/www/html/supportCfusion/MachII/mach-ii.cfc:210)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
      coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
      cfmach2dii2ecfc39383740$funcONREQUESTSTART.runFunction(/var/www/html/supportCfusion/MachII/mach-ii.cfc:121)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
      coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2620)
      coldfusion.runtime.SuperScope.invoke(SuperScope.java:18)
      coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
      cfApplication2ecfc929761844$funcONREQUESTSTART.runFunction(/var/www/html/i2report/Application.cfc:55)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
      coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
      coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
      coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
      coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
      coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
      coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
      coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108)
      coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:278)
      coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:419)
      coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
      coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
      coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
      coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
      coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
      coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
      coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
      coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
      coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
      coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
      coldfusion.CfmServlet.service(CfmServlet.java:219)
      coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
      coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      sun.reflect.GeneratedMethodAccessor89.invoke(null:???)
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      java.lang.reflect.Method.invoke(Method.java:597)
      com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:97)
      com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:472)
      com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:312)
      com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:192)
      com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:507)
      com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
      sun.reflect.GeneratedMethodAccessor88.invoke(null:???)
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      java.lang.reflect.Method.invoke(Method.java:597)
      com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:79)
      sun.reflect.GeneratedMethodAccessor87.invoke(null:???)
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      java.lang.reflect.Method.invoke(Method.java:597)
      com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:53)
      com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:???)
      org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
      org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
      org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
      org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
      org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
      org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
      org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422)
      org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:199)
      org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
      org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
      java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      java.lang.Thread.run(Thread.java:662)